Logic Help

[abhaysingh]

Hi All,

How to convert Year, week to Date and month?

pls find the sample data

[Anonymous]

use function makeweekdate

makeweekdate(Year,Week)

[swuehl · Accepted solution]

You can use MakeWeekDate() function:

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

Then apply Month() or MonthName() to the created date value.

...

MakeWeekDate( Year, Week) as Date,

MonthName( MakeWeekDate( Year, Week)) as MonthName,

...

[abhaysingh]

hi guys,

thanks, for revert, how i can fill missing dates??

[swuehl]

What do you mean with 'missing' in this context?

Are you talking about a master calendar?

The Master Calendar

Or more something like

Generating Missing Data In QlikView