RE: 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.

carelvdm Rookie Asked on November 12, 2020 in Saved Searches.
Add Comment
2 Answers

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.