Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have Date field like this "CREATEDDATE_WW" This filed has to be restricted to last 6 weeks from the current week . suppose if i move to next week i have to get the data for last 5 weeks.
@GURRAMVEN
You can create a rule in your load script, using Today() function, so every time you reload is will refresh for the "new" las 6 weeks.
In this post Displaying last week's data you can see how to load data for the previous week, the same logic can be used to load date for 6 weeks back.
I would also check this other post Only load data of last 4 weeks, that is not marked as solved but have good ideas on this topic.