Saved Search formula for week number
Answered
Hi – is there a function/formula for when you want to display the week number of a year? I’m currently using TO_CHAR({date},IW} which does give me the week number but I need the year plus week number. The problem with above mentioned formula is that 1 Jan 2021 is still week 53 of 2020 and should show 202053. But if I just just the calendar year plus above mentioned formula, then I get 202153.
Best answer
You probably want the ISO standard Year if you are using the ISO standard week number.
Brilliant – thanks, it works!