Importing date format

[Anonymous]

Hello,

I have two tables using a different time format. One uses "YYYY_WW" the other uses a standard "DD-MM-YYYY". When loading the data Qlik Sense has no problem with the second format, but I can't find a way to import the "YYYY_WW" format as a date usable in Qlik Sense. Can anyone help me with this?

[isingh30]

Can you share some sample?

[rubenmarin · Accepted solution]

Hi maybe with::

MakeWeekDate(Subfield(DateField,'_',1), Subfield(DateField,'_',2))

https://help.qlik.com/en-US/sense-cloud/Subsystems/CloudHub/Content/Scripting/DateAndTimeFunctions/m...