Using in Analysis:
"Date_Column" IN (TIMESTAMPADD(SQL_TSI_DAY,-1,CURRENT_DATE))
This will return yesterday's date - it is an alternative to CURRENT_DATE - 1.
Using Dashboard Prompt:
SELECT TIMESTAMPADD (SQL_TSI_DAY,-1,CURRENT_DATE)
Using Dashboard Prompt:
SELECT TIMESTAMPADD (SQL_TSI_DAY,-1,CURRENT_DATE)
FROM "Subject_Area_Name"
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.