Use Gregorian calendar week numbers instead of fiscal week numbers

fxlepoutre

Hello community, 

 

Currently Anaplan uses its own week numbering to determine the week number. When fiscal period is different from jan-dec, then week numbers do not match at all with calendar week numbers as defined in ISO 8601.

 

This makes it very confusing for users to adapt to these new week numbers, especially when users need to communicate with other parties (suppliers, customers) that do not rely on the same fiscal calendar. Typical example of confusion is those discussions: "When we discuss about W13, is this in the calendar or is this in your own fiscal calendar?" or "Which date is that week?". Answers to these questions are obvious when everyone uses ISO 8601 calendar that is displayed in Google Calendar, Windows and Microsoft Outlook. 

 

Therefore, Anaplan should have the option, in module's time settings, to use ISO week numbers instead of fiscal week numbers as a way to refer to weeks in Anaplan. This would then change the label of all weeks in the Time dimension, and would be used for display, but also for exports and imports.

Of course, this would mean that first week of fiscal year might not be week 1, but that's a minor setback for the user, because this is only very internal to the company's finance team. 

 

Thanks a lot for your upvotes. 

FX

fxlepoutre

Hello,

 

Another idea similar to this one: https://community.anaplan.com/t5/Idea-Exchange/Additional-week-formats/idi-p/34347

 

Also, we saw that there is the option to change the "Week Format" option in the Time settings to "Week Commencing" instead of "Numbered" (see https://community.anaplan.com/t5/Best-Practices/Untangling-Anaplan-Time-Mapping-in-Imports/ta-p/81611). This would still not allow to have Gregorian week numbers displayed in the interface, but would at least allow to have a little better understanding on which week we are in.

 

A cool implementation of the feature reported here would be to have the choice, in the "Week Format" option, to choose :

- "Numbered" (current)

- "Week Commencing" (current)

- "Week Ending" (current)

- "Numbered as of ISO-8601" (that would display "Week 5 FY23" for today's week)

 

Thanks,

FX

betinajessen

Try adding the Timezone offset first.   Or is there some fundamental printable 2023 calendar difference between how both regions represent the weeks?

var gdt = new GlideDateTime();

 

gdt.add(gdt.getTZOffset());

 

gs.print(gdt.getWeekOfYearLocalTime());