Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, how can i get data for different periods,
last day ,
last 7 days,
last month complete.
this year.
For last 1 day - ArrivalDate={'$(=Date(today()-1))'}
I am guessing you want this in the front end, right? Use set analysis with variable. Do you have a specific dataset you want us to help you with?
For Last Year - Call_Year={"$(=DATE(FLOOR(YearStart(Today())),'YYYY'))"}
For last 7 days - ,Call_Date={">=$(=Date(today()- 6))<=$(=Date(today()))"}
For last 1 day - ArrivalDate={'$(=Date(today()-1))'}