Reformat date

[#1]

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

[maxgro · Accepted solution]

you can define LongMonthNames

and use the MMMM format code

as explained here

Roman Emperors and the Month Names

[sunny_talwar]

May be this:

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

[PradeepReddy]

try some thing like this...

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

[tresesco]

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

[jagan]

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.

[Anonymous]

try like this?

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

[kkkumar82]

Hi,

Atlast I am attaching a file.

thanks

Kiran Kumar