2 Replies Latest reply: Jun 27, 2012 5:14 AM by giobenoni RSS

    Resident load from qvd with custom date format...

      Hi !


      First I'm loading an array of monthly qvd files, which works :



      LOAD * From Report_*.qvd(qvd);


      These qvd files have a field called Fiscal_Period, which shows the months and years in such way : 001.2010


      Now I would like to make a calendar out of this, but it doesnt work :


      LOAD * From Report_*.qvd(qvd);


      LOAD Fiscal_Period,
      MakeDate(Num(Right(Fiscal_Period,4)), Num(Mid(Fiscal_Period,2,2)),1) as OrderDate,
      Date#(Orderdate, 'YYMM') as FinalDate
      Resident Source_table


      It gives the error : OrderDate not found,


      What do I do wrong?