Description

Using the Greater Than '>' and Lesser Than '<' operators in DQL can be challenging until you understand their meaning.

These operators are generally used in time calculations in the query to produce a dataset for a certain period.

The Greater Than Operator is used to calculate the time from today (the day that the report is executed) back.

The Lesser Than Operator is used to calculate the time before the specified duration.

For example, if I run a report on 30 JAN 2024 using last_accessed > duration ('36 months'), it will return data that has a last accessed time (atime) between 30 JAN 2021 and 30 JAN 2024, 36 months from 30 JAN 2024 back.

 If we reverse the operator and use last_accessed < duration ('36 months'), it will return data with a last accessed time before 30 JAN 2021, 36 months and older from 30 JAN 2024.

Please refer to the Veritas Data Insight Programmer's Reference Guide included with the installation package for Data Insight for additional details and examples.