Solved: Convert YYYY-WW to Date - Page 2 - Qlik Community

Report Inappropriate Content · ‎2013-09-02

Hello,

Is it possible to convert a YYYY-WW date format into a single date? Lets say the last day of that week?

kaushiknsolanki · ‎2013-09-02

Ralf,

.

you are also right.

Better you use the solusion i have suggested with checking the lenth, you can also try the solution given by Ori.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

jagan · ‎2013-09-02

Hi,

Try like this

=MakeWeekDate(left('2013-02',4), Num(SubField('2013-02', '-', 2)))

Regards,

Jagan.

rbecher · ‎2013-09-02

Or subfield:

=MakeWeekDate(subfield('2013-2','-',1),subfield('2013-2','-',2),0)

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine