--- title: "Date strings" slug: "date-strings" updated: 2025-09-15T16:50:44Z published: 2025-09-15T16:50:44Z canonical: "docs.supermetrics.com/date-strings" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt > Use this file to discover all available pages before exploring further. # Date strings Query date strings for a Supermetrics API query can be provided either as fixed dates, or as a relative dates. ## Supported formats ### Fixed date Fixed date should always be in the format of `YYYY-MM-DD`. ```plaintext {"start_date":"2020-04-01"} ``` ### Unix timestamp Unix timestamp is the number of seconds since Jan 1st 1970 UTC. When using a unix timestamp, it should be prefixed with an at-sign. Only UTC date precision is used and time of day is ignored. ```plaintext {"start_date":"@1585755000"} ``` ### Relative date Relative date is a human-friendly string that can be translated into a date. They are treated as an offset from the current time. Relative dates use keywords written in English. ```plaintext {"start_date":"previous Monday"} ``` ## Examples ### Example 1 Date range from a fixed date into yesterday. ```plaintext {"start_date":"2019-01-01", "end_date":"yesterday"} ``` ### Example 2 Start date is 2 weeks ago and moves with the current day. ```plaintext {"start_date":"-2 weeks", "end_date":"today"} ``` ### Example 3 Start date is not just moving but also a specific week day. ```plaintext {"start_date":"-2 weeks next Monday", "end_date":"today"} ``` ### Example 4 Date range from a unix timestamp into yesterday. ```plaintext {"start_date":"@1577836800", "end_date":"yesterday"} ``` ## Resources A good set of relative date formatting rules and examples are available in the [PHP language documentation](https://www.php.net/manual/en/datetime.formats.php#datetime.formats.relative).