1 Reply Latest reply: Mar 21, 2012 5:34 PM by nhsharon RSS

    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.

       

      LOAD b2_num,

           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.

      Would you please help?

       

      Thanks.

       

      Sharon