Date Input Notation

When querying for points, the date from and date to must be specified in one of the ways below.  To show more recent dates first, flip date from and date to.

1. MIN / MAX – queries for the minimal or maximal dates
2. Relative Period format – see below for examples and reference
3. ISO date – either YYYY-MM-DD or YYYY-MM-DD MM:HH or YYYY-MM-DD MM:HH:SS
4. milliseconds since epoch – any numeric input will be interpreted as milliseconds from epoch (for example 2020 means 2020 milliseconds since epoch, NOT the year 2020)
5. Native date – this format depends on the tool used
• Excel uses a reference to a cell containing a date or a DATE(YYYY,MM,DD) function or a SJDATE(YYYY,MM,DD,HH,SS) function
• Python uses a datetime() object
• C# uses a DateTime object
• See specific tool documentation for more example and details

Date Input Operators

Note that date input operators are only supported in df/dt, and not when using dates as parameters to operators (e.g. in @asof:-2db there is no support for further operating on the -2db).