Date Format

alec1982 — Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Date Format

rustyfishbones — Thu, 02 May 2013 19:19:27 GMT

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

topic Date Format in QlikView

Date Format

Re: Date Format