Custom Date Tricks in Dataslayer

Do you want to learn how to have more control over the time range in your queries? Here's how to do that!

If you use our tool for Google Sheets, Microsoft Excel, API Query Manager, or BigQuery you probably know the option to define the date range of your query.

You will see that there are 2 options to select the range: by calendar and by predefined fields:

Additionally, our developers have implemented some advanced features that allow you to enhance your experience even further. These are known as Custom Date Tricks: special keywords you can enter in the date fields to specify dates in a more personalized manner, rather than just using numerical values.

Which tricks can be used and how?

• You can use words like: "now", "yesterday", "today", "tomorrow", "last Sunday", "Next Friday, "this Saturday". Also, more complex requests such as "First day of this month last year", "Today, 2 years ago", "Today - 1 week, 2 years ago".
• You can use the date format "DD month YYYY": "1 May 2024". "8 January 2021"...
• You can use operations like: - 15 days, + 5 hours, +1 week...
• And of course, you can also combine all the mentioned!

For example:

1 May 2024 - 15 days to last Sunday

Today - 1 week, 2 years ago to last Sunday

As always, please do not hesitate to contact us via our live chat on our website or via e-mail if you still have doubts or questions. We are happy to help!