Master Calendar

[#1]

Hi ,

I am trying to create the master calendar with the Week start as Friday. I am able to create the master calendar without any issues it is working good . But i am not able to get the weekstart as friday.

[Anonymous]

You can use weekstart with parameters:

weekstart(Date, 0, -3) as WeekStart.

Regards,

Michael

[#3]

Thanks for your response mIchael, So the offset -3 will indicate that Friday is the starting day of the week not the Monday. Is there any other thing has to changed in the master calendar.

[Anonymous]

I can't tell without seeing your calendar.  Just try and see waht happens.  If there are additional problems, post here.