Convert string to date

[vinod1992]

Hi All,

I have string format as jan'19, How to convert that string into date format?

Thanks & Regards,

Vinod

[crusader_ · Accepted solution]

Hi,

First thing to do is replace ' symbol with something neutral like -, then apply DATE#() function to tell Qlik explicitly that this text is a date. You should get something like below.

DATE#( REPLACE(<YourField>,chr(39), '-'), 'MMM-YY')  AS <YourDateField>

You can additionally apply DATE() function on top to convert to your default date format, also note that your Jan'19 will be 01/01/2019.

Hope this helps.

//Andrei

[Channa]

date(date,'MMM YY')

date(date#(date,'MMM YY'),'MMM YY')

try

[Shubham_Deshmukh]

Hi Vinod,

You need to replace ' with - first and then you can proceed, try this : 

=Date(Date#(Replace(yourDate,chr(39),'-'),'MMM-yy'),'MM/yy')

-Shubham

[tresesco]

So here the single quote (') is something that is annoying you, right? If so, you could use escape sequence, like:

=Date(Date#(YouraDate, 'MMM''YY'))

Note the double single quotes in red. For better understanding, refer : Escape Sequence in Qlik

[Shubham_Deshmukh]

@tresesco ,

Thanks for the tip, it works.

[tresesco]

That means you liked it, but still didn't LIKE it..

[Shubham_Deshmukh]

Done !!

[vinod1992]

Thanks Shubham It worked

[Shubham_Deshmukh]

Kudos!!