Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

jipprinsen
New Contributor

Importing date format

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?

1 Solution

Accepted Solutions

Re: Importing date format

Hi maybe with::

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

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

2 Replies
isingh30
Contributor III

Re: Importing date format

Can you share some sample?

Re: Importing date format

Hi maybe with::

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

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