Here are some conventions to be followed while applying Filter on Date/time fields
- Value of time column should be in the format of {t 'hh:mm:ss'}
- Value of date column should be in the format of {d 'yyyy-mm-dd'}
- Value of timestamp column should be in the format of {ts 'yyyy-mm-dd hh:mm:ss'}
Note: Column name should be always enclosed with Double quotes ("ColumnName")
Examples:
TIME - "FactoryTime" > {t '10:20:51'}
DATE - "OrderDate" > {d '2018-06-28'}
TIMESTAMP - "ExactTimeStamp" > {ts '2018-06-28 00:00:00'}