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 28-day 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.
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 PI-AF to return the ISO week number for a given timestamp.