Date format

[#1]

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.

[giakoum]

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.

[#3]

Hi Loannis,

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

Regards,

kv.