How to Get dates based on the week ending date

[rajua99]

Hello,

I would like to get the dates for that week based on week ending date. There are 2 columns in the database one is day of the week which stores as 1,2,3,4,5,6,7 and there is Week Ending Date filed. The week ending date field is the Sunday of each week.

In my report where there is 1 i need to display the date for that week i.e Monday date. If it is 2 then Tuesday date.

For example if the week ending date is April 3 2016, then for 1 i need to display as 28th March and for 2 March 29th ....and for 6 April 2nd...

How to create this type of variable in Report studio to get the dates for each week based on Week Ending Date.

Our Database is IBM AS400.

Thanks,
Raju

[navissar]

You go back 7 days and then add the day number, e.g.:
_add_days([enfofweek],-7+[dayinweek])