I wrote following condition and its giving date starting from Friday. I need to modify this to get week start from Monday.
i tried weekstart(Load_Date) but its giving from Sunday
Any idea on how to get from monday ?
May be this:
Also make sure you have this in your environmental variables in script:
= weekstart(Load_Date) + 1
the variable FirstWeekDay doesn't changed anything for me.
the second Parameter of the weekstart function sets the startday of the week (0 = Monday)
Retrieving data ...