Date And Datetime Filter Values

Meta Integration supports the following date or datetime filter values:

• LAST <n> DAYS | HOURS | MINUTES, where <n> is a positive integer
• Date constants:
  • Date keywords: TODAY, YESTERDAY
  • Date value in the form of 'yyyy-MM-dd', such as '2010-10-05'
  • Datetime value in the form of 'yyyy-MM-dd hh:mm:ss', such as '1998-01-01 01:00:00'

All date and datetime values are treated as UTC (Coordinated Universal Time).
‎
‎LAST <n> DAYS | HOURS | MINUTES can only be used as the filter value of = operator.
‎
‎All date constants can be used as the filter value of =, BEFORE, AFTER and BETWEEN operators.

Note that the date keywords TODAY and YESTERDAY may have a different meaning used with different operators. For example:

• "Updated Date" = TODAY means the last modification time is between '00:00:00' and '23:59:59' of the current calendar day.
• "Updated Date" BEFORE TODAY means the last modification time is before '00:00:00' of the current calendar day.
• "Updated Date" AFTER YESTERDAY means the last modification time is after '23:59:59' of the last calendar day.