topic Date format in QlikView

Date format

Tue, 11 Dec 2012 09:27:17 GMT

Hi all,

I have got a field name as ARRIVAL_DATE in the format 'DD/MM/YY' and another field name as ControlDate (Master calendar)

I need to assign ARRIVAL_DATE as CONTROLDATE with the above format.

I have tried

1. Date([ARRIVAL_DATE], 'DD/MM/YY') as CONTROLDATE

2. Date(Date#([ARRIVAL_DATE], 'DD/MM/YY')) as CONTROLDATE

None of the ablove two statements seems to work. Can I get some help with this please.

Regards,

kv.

Re: Date format

giakoum — Tue, 11 Dec 2012 09:40:50 GMT

It looks like you have dates in different format, so QV does not indentify this field as date. What you need to do is load it in the correct date format. Otherwise, not recommended though, use the num function. Dates are understood a s numbers by QV.

Re: Date format

Tue, 11 Dec 2012 10:01:41 GMT

Hi Loannis,

There is no way I could change the date format in the data as I have millions of records.

Regards,

kv.