Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

Reformat date

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

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Reformat date

you can define LongMonthNames

and use the MMMM format code

as explained here

Roman Emperors and the Month Names

View solution in original post

7 Replies
MVP
MVP

Re: Reformat date

you can define LongMonthNames

and use the MMMM format code

as explained here

Roman Emperors and the Month Names

View solution in original post

Re: Reformat date

May be this:

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

pradeepreddy
Valued Contributor II

Re: Reformat date

try some thing like this...

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

MVP
MVP

Re: Reformat date

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

MVP & Luminary
MVP & Luminary

Re: Reformat date

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.

balrajahlawat
Esteemed Contributor

Re: Reformat date

try like this?

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

kkkumar82
Valued Contributor III

Re: Reformat date

Hi,

Atlast I am attaching a file.

thanks

Kiran Kumar