Forum Discussion

lightyearsboi's avatar
lightyearsboi
Regular Visitor
6 years ago

ISO 8601 Year

Hi all,   I am using the below to add a column for the ISO week number in my calendar and it works great.   What I also need is a column to show ISO year... So for 30/12/19, it would show as 2020...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI lightyearsboi 

 

 

yearISO = SWITCH(TRUE()
                ,_weeknum = 1 && _month = 12, YEAR([Date]) + 1
                ,_weeknum > 50 && _month = 1, YEAR([Date]) - 1
                , YEAR([Date])

 

 

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)