Using Absolute Dates in SINCE/UNTIL in ShopifyQL

PriyanFernando
New Member
1 0 1

Hi,

I am trying to run the following ShopifyQL report:

"SHOW net_quantity, total_sales BY day, product_id FROM sales SINCE 2019-09-02 UNTIL 2019-09-04"

However I am getting the following error:

{'errors': {'shopify_ql': ['query requires relative SINCE field']}}

The syntax for SINCE/UNTIL looks correct as per: https://shopify.dev/docs/admin-api/rest/reference/analytics/shopify-ql#time-range-since-until

Please advise me on how to resolve this please?

Thank you,

Priyan.