MakeWeekDate

[#1]

Hi,

     How does qlikview interprets it

    makeweekdate(1999,6,6) returns 1999-02-14

With Regards,

Sudharshan

[swuehl]

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.

Examples:

makeweekdate(1999,6,6) returns 1999-02-14

makeweekdate(1999,6) returns 1999-02-08

In your example, you are requesting the date for the 6th day of week 6 in year 1999 (week numbering and week days according ISO).

[maxgro]

day of week     6               --> sunday (3rd parameter)

week                6               --> of the 6th week (2nd parameter)

year                  1999         --> of year 1999 (1st parameter)

is (I think)  the date 14 feb 1999