Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

sqlpuzzle
New Contributor III

year and weekofyear to MMM-dd-YYYY format

Hi,

 

I have a data set that has  year and weekof year in it. I need to derive two fields,

week begin date (MMM-dd-YYYY) format

week end date (MMM-dd-YYYY) format.

Is this possible?

I am attaching my sample

Labels (1)
1 Solution

Accepted Solutions
Highlighted
ThePeterK
New Contributor III

Re: year and weekofyear to MMM-dd-YYYY format

Does this get you what you need?:

 

=weekstart(date(YearStart(makedate(2019))+weekofyear*7))

=weekend(date(YearStart(makedate(2019))+weekofyear*7))

93/93
1 Reply
Highlighted
ThePeterK
New Contributor III

Re: year and weekofyear to MMM-dd-YYYY format

Does this get you what you need?:

 

=weekstart(date(YearStart(makedate(2019))+weekofyear*7))

=weekend(date(YearStart(makedate(2019))+weekofyear*7))

93/93