Current weeknumber showing incorrectly (i.e. next week)

[Dayna]

Hello,

I have a very simple measure to get the current week number, as below:

Today (Week) = FORMAT(TODAY(), "YYYY/WW")

Today, being May 19th, belongs to week 20 in the calendar. However, this measure returns 2022-21.

Does anyone have any ideas why this is the case or how I can change it so it accurately reflects the current week, please?

Many thanks,

Dayna

[ribisht17 · Accepted solution]

@Dayna 

You have a point here,

This is taking the 1st of Jan as the first week, 

So, I need to go back by 1 week with the below probably 🙂

Today (Week) = FORMAT(TODAY()-7, "YYYY/WW")

Regards,

Ritesh

[Dayna]

Thank you all!

[Samarth_18]

Hi @Dayna ,

Please try this:-

Today (Week) = FORMAT(TODAY(), "YYYY/"&weeknum(today(),21))

Output:-

BR,

Samarth

[Dayna]

Hi @Samarth_18 that works, but can you explain what the ,21 is doing, please?

[Samarth_18 · Accepted solution]

Hi @Dayna , Its calculating week number based on ISO 8601.

[ribisht17 · Accepted solution]

@Dayna 

You have a point here,

This is taking the 1st of Jan as the first week, 

So, I need to go back by 1 week with the below probably 🙂

Today (Week) = FORMAT(TODAY()-7, "YYYY/WW")

Regards,

Ritesh