Using Absolute Dates in SINCE/UNTIL in ShopifyQL

New Member
1 0 1


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:

Please advise me on how to resolve this please?

Thank you,