How to get calmonth/caldate from calweek

[SvenBoetius]

Hello,

I have a date in calweek format and need to get the 12 (full!) Months before that. For this I either need to derive the starting date of the week, or directly the month of the first day in the week..

I can't immagine this to be such a big problem, but so far I couldn't find a sollution.

[SvenBoetius]

example:

Today we have week 43. If I just get the date in this format '201843': How can i derive the 22.10. as start of the week (Monday)or just the November as month?

[raymond_giuseppi]

You didn't find the good old WEEK_GET_FIRST_DAY during your search?

[SvenBoetius]

huh... thank you!

Somehow I actually missed that.