Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor II

Convert text to date format

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

Tags (2)
1 Solution

Accepted Solutions
Highlighted
New Contributor II

Re: Convert text to date format

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.

View solution in original post

3 Replies
Highlighted
Contributor II

Re: Convert text to date format

Hi!

Can you please provide example in excel file

Thanks,

Vitalii

MVP & Luminary
MVP & Luminary

Re: Convert text to date format

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

Highlighted
New Contributor II

Re: Convert text to date format

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.

View solution in original post