topic Re: Convert text to date format in QlikView

Convert text to date format

abg_emea — Wed, 25 Nov 2020 16:16:04 GMT

Hi There,

I am very new to qlik and I have been looking on these forums for a while and checking Google but I can't seem to find a working answer. I have a file that is received weekly that I want to be upload (without modification) into QLIKCLOUD, so the manipulation is all done automatically inside Qlik.

I have most of it working however it has a date field which is formatted as "November 1,2018" or "June 29,2018" etc, I have tried the following with no luck:

Date#(Date([Date],'MMMM DD,YYYY'),'YYYY.MM.DD') as 'Visit Date'

If anybody can offer some help it would be great.

Thanks

Dave

Re: Convert text to date format

vitaliichupryna — Thu, 01 Nov 2018 12:51:09 GMT

Hi!

Can you please provide example in excel file

Thanks,

Vitalii

Re: Convert text to date format

rwunderlich — Thu, 01 Nov 2018 12:54:10 GMT

You just have your "#" backwards, it should be the inner function like this:

Date(Date#([Date],'MMMM DD,YYYY'),'YYYY.MM.DD') as 'Visit Date'

Date#(field, format) means "read date string using this format"

Date(field, format) means "display this date field using this format"

-Rob

Re: Convert text to date format

abg_emea — Thu, 01 Nov 2018 13:55:11 GMT

Got it working - needed a couple of tweaks:

Date(Date#([Date],'MMMM DD, YYYY'),'YYYYMMDD') as 'Visit Date',

Thanks Rob - put me in the right direction.