Setting a deviating start of the week

[datanibbler]

Hi,

I know there have been a nr. of discussions here about deviating fiscal years.

I wonder, is it also possible for weeks - to define a deviating start_day - in this instance, a week should start on Thursday and run till Wednesday. The calendar_week would then be different, too - a few days of every cw would be moved into the one before, so to speak.

Is it possible to generate a calendar - only for that specific purpose, so I wouldn't touch the master_calendar - that has this deviating week_structure?

Thanks a lot!

Best regards,

DataNibbler

[Gysbert_Wassenaar · Accepted solution]

See this blog post: Redefining the Week Start

And perhaps this one too: Redefining the Week Numbers

[#3]

Hi Data,

the InWeek function allows for an optional weekstart offset to be entered, should be able to create a flag from this for use in your master calendar (or outside as you say).

Same with weekstart & weekend, all allow the offset.

Hope that helps

Joe

[datanibbler]

Hi Gysbert,

many thanks!

The Weekstart() function and its offset_parameter are just what I discovered just now in the integrated help. It is very relieving to see that the pros suggest just that.

You can define the calendar_week and everything else based on that - it's only slightly more typing as you always need that offset - with functions that don't have one, you have to nest the Weekstart() function inside to have it.

Best regards,

DataNibbler

[datanibbler]

Hi Joe,

yes, that's what I found in the integrated help and I'm relieved to see that the pros in their design_blogs suggest nothing else.

Thanks a lot!

Best regards,

DataNibbler