Week to Date format

[RKGV]

Hi Guys

I want to convert week to date (Last day of the Week) format. 

can someone help pls>

regards

Rajesh

[atcodedog05]

Hi @RKGV 

What's the logic? your numbers translate to these dates. Can you provide more clarity

Hope this helps : )

[RolandSchubert · Accepted solution]

Hi @RKGV ,

some DateTime functions should do the job:

You should first split week number and year - for 1 digit weeks, add the leading "0".

Then calculate the first day of the year, which leads to the start of "week 1". For each week add 7 days and you should be done.

Let me know if it works for you.

Best,

Roland

[atcodedog05]

Oh, now it makes sense 😅 nicely done @RolandSchubert 🙂👍

[RKGV]

Thanks. Works perfectly fine :)

[AlexAppelqvist]

Hello, this doesn't always seem to work. I found that starting in 2026, the results are off by a week. Thoutghs?