topic Re: Convert text Date format 'Week WW YYYY' to Weekname YYYY/WW in QlikView

Convert text Date format 'Week WW YYYY' to Weekname YYYY/WW

mazacini — Wed, 24 Jun 2015 09:44:19 GMT

I have a text field in the format Week 13 2015

I want to convert it into a date format.

Any ideas?

Thanks

Joe

sunny_talwar — Wed, 24 Jun 2015 09:49:33 GMT

You want to convert it into date or YYYY/WW??

swuehl — Wed, 24 Jun 2015 09:51:12 GMT

This will give you the weekstart date:

=MakeWeekDate(subfield('Week 13 2015',' ',3),subfield('Week 13 2015',' ',2))

edit:

From the weekstart date, you can create any format you like, using Weekname(), Week() and WeekYear() function.

mazacini — Thu, 25 Jun 2015 22:18:54 GMT

Thank you - worked great!