Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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
If(Weeks='DMD1',date(LOAD_DATE)
Any idea on how to get from monday ?
May be this:
If(Weeks='DMD1', WeekStart(Date(LOAD_DATE)))
Also make sure you have this in your environmental variables in script:
SET FirstWeekDay=0;
Try
= weekstart(Load_Date) + 1
Hello uday,
the variable FirstWeekDay doesn't changed anything for me.
try this:
If(Weeks='DMD1',weekstart(date(LOAD_DATE),0,0))
the second Parameter of the weekstart function sets the startday of the week (0 = Monday)