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'}