apatten

Comments

That seems to have worked! Thank you!

in Add Data that has been modified in the last 7 days Comment by apatten July 2022
This is as I am pulling the data from snowflake to Domo. In the dataset configuration within Domo

in Add Data that has been modified in the last 7 days Comment by apatten July 2022
I have run it with a few different variations of this query so I have gotten a few errors. CURDATE is not a valid function Unexpected value of '7', meaning the 7 day interval Invalid identifier with 'interval' Unexpected with 'day' I have tried variations with a BETWEEN function, ADDDATE, SUBDATE and GETDATE

in Add Data that has been modified in the last 7 days Comment by apatten June 2022
ORDER_MODIFIED_TIME is in a date time format (yyyy-mm-dd hh:mm:ss) . I will try using the back tick too.

in Add Data that has been modified in the last 7 days Comment by apatten June 2022