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.
The following is my script.
text(mid(b3_num,7,8)) as CREFNO,
date(das_date) as 'das date',
date(cancelled) as 'cancel date',
day(cancelled) as 'cancel day',
month(cancelled) as 'cancel month',
year(cancelled) as 'cancel year',
isnull(cancelled) as 'datenull',
[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.
Would you please help?