Add a function to calculate the week number of the year
In order to calculate the current shift operating at a plant, I need to calculate where in the 28day cycle the current week is. Knowing which week of the year it is allows me to do that. Note that current PI weekday functions always count Sunday as Day 1, while some Excel functions count Monday as Day 1. It might be important to have an option to specify which day of the week is Day 1.
3 comments

Thank you for your comment.

Emilio Sancha Herrera commented
From my point of view it would be essential that the week number returned was that established by ISO 86001 (The first week of the year is one that contains the first Thursday of the year)

Daniel Gougeon commented
The ISO week number is a very useful Excel function when managing roll up summary reports and pivot table. It would be extremely useful to have the ability in PIAF to return the ISO week number for a given timestamp.