Welcome‎ > ‎Version 3‎ > ‎Reference Info‎ > ‎

Date Filters

When attempting to filter by date, there are several supported formats.

20101020                            Find date matching October 20, 2010
20100422-20101020            Find date between April 22, 2010 and October 20, 2010
ALL                                     Find date between January 1, 1970 and January 1, 2038
FUTURE                               Find date between today's date and January 1, 2038
PAST                                   Find date between January 1, 1970 and today's date.
TOMORROW (or +1D)            Find date between tomorrow's date and the day after.
YESTERDAY (or -1D)             Find date between day before yesterday and yesterday.
t<UnixTimeStamp>-t<UnixTimeStamp>         Find date between Unix timestamps.

Examples

StartDate=TOMORROW
EndDate=20101020-20101031
DateRange=t1317427200-t1320019200 (Oct 1, 2011 to Oct 31, 2011 23:59:59)

Note All date related functions are in UTC.  Unix timestamps are in the format described here.  Free unix timestamp converters can be found online, e.g. here.
Comments