topic Date Conversion in QlikView

Date Conversion

sunil2288 — Sun, 18 Jul 2010 12:13:17 GMT

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 — Sun, 18 Jul 2010 12:16:52 GMT

Hi,

Use the date function while loading the table. Eg:

Load

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

From file;

wizardo — Sun, 18 Jul 2010 12:42:16 GMT

try this

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

sunil2288 — Fri, 31 Dec 2010 10:05:39 GMT

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