Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sunil2288
Creator III
Creator III

Date Conversion

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

1 Solution

Accepted Solutions
wizardo
Creator III
Creator III

try this

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

View solution in original post

3 Replies
syed_muzammil
Partner - Creator II
Partner - Creator II

Hi,

Use the date function while loading the table. Eg:

Load

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

'

'

From file;

wizardo
Creator III
Creator III

try this

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

sunil2288
Creator III
Creator III
Author

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