Hi Madan,
If you want the Start Date to be the 1st day of the week on which you run the report, then you can use the following FMs:
DATE_GET_WEEK: To get the week in which a date lies.
WEEK_GET_FIRST_DAY :To return first day for a particular week
Reward points for useful answers.
Hi,
Please use the FM 'DATE_COMPUTE_DAY'.
With this FM you can get the day of the week using the current date.
for e.g. 0 stands for Monday,1 for Tuesday, 2 for Wednesday,3 for Thursday.
Once you get the day then you can subtract the exact no of days to get the get of Monday.
Hope it was useful.
Thanks,
Sandeep.
Add comment