Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Data Warehouse - Start of Month and Last Full Week format


Level 1

Hi, I'm using a Data Warehouse API for another website. I'm looking to find the right format for date queries so I can pull data from 'Start of Current Month' and data from 'Last Full Week'. I currently have the below:

"dateTo": "{'GMT+10:00').today}", which I know pulls today's data.

Thank you!

1 Reply


Employee Advisor

Hi Martin, could you provide clarification on what exactly your question is?