Convert text to date format

[abg_emea]

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

[vitaliichupryna]

Hi!

Can you please provide example in excel file

Thanks,

Vitalii

[rwunderlich]

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

[abg_emea · Accepted solution]

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.