topic Re: Reformat date in QlikView

Reformat date

Thu, 04 Feb 2016 20:14:01 GMT

Hi,

I have the following dates imported from an excel file:

December 1, 2015

December 2, 2015

December 3, 2015

December 4, 2015

How would I format them to mm/dd/yyyy in the import script?

Best,

Matt

Re: Reformat date

maxgro — Thu, 04 Feb 2016 20:27:10 GMT

you can define LongMonthNames

and use the MMMM format code

as explained here

Roman Emperors and the Month Names

Re: Reformat date

sunny_talwar — Thu, 04 Feb 2016 20:37:49 GMT

May be this:

Date(DateField, 'MM/DD/YYYY') as DateField

Re: Reformat date

PradeepReddy — Fri, 05 Feb 2016 06:42:25 GMT

try some thing like this...

Date(Date#(Date_Field,'MMMM DD, YYYYY'),'YYYY-MMM-DD') as Date_Field_New

Re: Reformat date

tresB — Fri, 05 Feb 2016 06:54:54 GMT

Date(Date#(Date_Field,'MMMM DD, YYYYY'), 'MM/DD/YYYY') as Date_Field_New

Re: Reformat date

jagan — Fri, 05 Feb 2016 07:04:59 GMT

Hi,

Try like this

Data:

LOAD

Date(Date#(DateFieldName,'MMMM DD, YYYY'), 'MM/DD/YYYY') AS DateField_New

From DataSource;

Hope this helps you.

Regards,

jagan.

Re: Reformat date

Anonymous — Fri, 05 Feb 2016 07:05:08 GMT

try like this?

=date(date#(YourDateField,'YourExcelDateFormat'),'YourRequiredFormat') as NewDate

Re: Reformat date

kkkumar82 — Fri, 05 Feb 2016 10:08:42 GMT

Hi,

Atlast I am attaching a file.

thanks

Kiran Kumar