last 5 weeks of data variable

[bhawana]

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

[dplr-rn]

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')

[dwforest]

Taking what Dilipranjith provided:

Date(WeekStart(today())-1,'MM/DD/YYYY') - 35  //7*5 = 35 days