week start on monday

[#1]

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 ?

[sunny_talwar]

May be this:

If(Weeks='DMD1', WeekStart(Date(LOAD_DATE)))

[sunny_talwar]

Also make sure you have this in your environmental variables in script:

SET FirstWeekDay=0;

[Anonymous]

Try

= weekstart(Load_Date) + 1

[zhadrakas]

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)