Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
alec1982
Specialist II
Specialist II

Date Format

Hi guys,

I have loaded a date field coming from Sharepoint list and the format in it  MMM DD YYYY

I am trying to change the format so I did Date(Fieldname,''M/D/YYYY') as Date1

But the result wasn't as expected. the field is not ahowing any data in it.

I am not sure if that's because QV is not recognizing the field as date?!

Please let me know your thoughts.

Best,

Alec

1 Solution

Accepted Solutions
rustyfishbones
Master II
Master II

You need to put the Input Format and then the Output format

Like below

DATE( DATE#( FieldName, 'MMM D YYYY'), 'YYYY-MM-DD') as Date1

That should do it

DATE# converts the Input Date to a serial number and the Output format ensures it reads the serial number and converts that to the correct date format

Regards

Alan

View solution in original post

1 Reply
rustyfishbones
Master II
Master II

You need to put the Input Format and then the Output format

Like below

DATE( DATE#( FieldName, 'MMM D YYYY'), 'YYYY-MM-DD') as Date1

That should do it

DATE# converts the Input Date to a serial number and the Output format ensures it reads the serial number and converts that to the correct date format

Regards

Alan