Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Use the date function while loading the table. Eg:
Load
date(Date_feild,'DD/MM/YYYY') as Date,
'
'
From file;
try this
date(date#(Date_field, 'MM/DD/YYYY'),'DD/MM/YYYY') as Date,
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