Weekstart day result is not getting as expected

[krishna20]

Hi Folks,

I am trying to create a weekstart days for all months and Monday is starting day of week.

But I am not getting result as expected and getting additional days .

The highlighted Mon-27th is belongs to Oct month in calendar. But, it's falling under Nov Month.

I haven't loaded Oct month data in my app.

PFB script and screenshot and advise.

Num(Month(Master_Date))& '-' & Day(weekstart(Master_Date,0))  as ACDWeekMonth

Thanks

Krishna

[jonathandienst]

Maybe you have more than one year in your data?

[krishna20]

I am loading only Nov , Dec and Jan till date data.

[krishna20]

Can anyone show light on this issue.

[sunny_talwar · Accepted solution]

Try this may be

Num(Month(WeekStart(Master_Date, 0)))& '-' & Day(WeekStart(Master_Date, 0))  as ACDWeekMonth

[krishna20]

Thank you very Much That's worked perfectly.