Formulas no longer working on QV 11

Hi,

I am trying to load information from an excel file(.xlsx), and I have formatted some of the contents, but found the following formulas no longer working on the new QV 11.

1. Day
2. Month
3. Year
4. Isnull
5. Date

The following is my script.

b3_num,

text(mid(b3_num,7,8)) as CREFNO,

b2_submit,

date(das_date) as 'das date',

refund_amt,

cheque_dat,

cheque_num,

cancelled,

date(cancelled) as 'cancel date',

day(cancelled) as 'cancel day',

month(cancelled) as 'cancel month',

year(cancelled) as 'cancel year',

isnull(cancelled) as 'datenull',

reject_dat,

resub_date,

b3_date,

auditor,

client_ref,

expl,

justify,

submitted

FROM

[C:\Documents and Settings\shua\Desktop\mmi8-20120319B2STAT.xlsx]

(ooxml, embedded labels, table is mmi8);

but the output does not come out the way it was in QV 10.

Thanks.

Sharon

• Formulas no longer working on QV 11

Figured it out, it was because of the date format.

Thanks.

Sharon