Date Conversion

[sunil2288]

Hi Everyone,

How to convert date format From'mm/dd/yyyy' to 'dd/mm/yyyy'

My Excel file have date field in the format 'dd/mm/yyyy' so i nedd in this format

Please help me ..

Thanks

Suneel

[syed_muzammil]

Hi,

Use the date function while loading the table. Eg:

Load

date(Date_feild,'DD/MM/YYYY') as Date,

'

'

From file;

[wizardo · Accepted solution]

try this

date(date#(Date_field, 'MM/DD/YYYY'),'DD/MM/YYYY') as Date,

[sunil2288]

Hi Wizardo,

Any way i found the solution to this thread ...

At the time when we r loading from the excel sheet ...The date should be in correct format...

Regards

Sunil