How to get the month by passing a specific week as parameter in expression.

[#1]

Hello All,

I have just started working on QV.

I am stuck at one place. I need to get the month for a specific week.

The expression I am using here is

" =month(week(today())-1)"

it returns me January as month which is incorrect, it should return March.

Any help on this would be deeply appreciated.

Thanks,

Punit

[maxgro · Accepted solution]

try with

Month(makeweekdate(Year, WeekNum))

from online help

MakeWeekDate(YYYY [ , WW [ , D ] ] )

Returns a date calculated from the year YYYY, the week WW and the day-of-week D.

If no day-of-week is stated, 0 (Monday) is assumed.

[#3]

Thank you Massimo!!

It solved my problem.