Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have to create a variable that has complete last 5 weeks of data and start date must always be saturday even if today is mid day of the week. I have a date field in the app.
How can I do this?
Thanks
in advance
not completely clear on your requirement.
please elaborate with example.
to get the previous saturday to today you can use below expression
Date(WeekStart(today())-1,'MM/DD/YYYY')
Taking what Dilipranjith provided:
Date(WeekStart(today())-1,'MM/DD/YYYY') - 35 //7*5 = 35 days