Saved Search formula for week number

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.

Rookie Asked on November 12, 2020 in Saved Searches.
Add Comment
2 Answer(s)
Best answer

You probably want the ISO standard Year if you are using the ISO standard week number.

Advanced Answered on November 12, 2020.

Brilliant – thanks, it works!

on November 24, 2020.
Add Comment

Thanks – I’ll try that

Rookie Answered on November 12, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor