DATE: Compare Date and Time

Use the DATE formula function in a situation, query, query-based view filter, or table view threshold formula to compare the time stamp from the data sample with the value specified.

DATE function Compare date/time
This is the default function for time attributes. It compares the Timestamp value from the data sampling with the value entered here.
After you select the DATE function and click inside the value cell, the Select the Time Comparison dialog opens for selecting the exact date and time to compare. The format is the date as seen in the date columns (mm/dd/yy hh:mm:ss) or as defined for your locale.
Example
This formula checks the Timestamp attribute value. When it matches the date set here, the comparison is true.
DATE(Timestamp)
== 09/30/03 23:59:00