5 Replies Latest reply: Dec 24, 2009 11:25 AM by asimakin RSS

    Missing Date Values from Master Calendar

      Dear All,

      Please check my attached QV file and the source excel file. I have sort the TARIH field with below statement:

      LOAD * RESIDENT EXCEL1 ORDER BY TARIH ASC;

      But my master calendar doesn't catch the 2000 and 2001 years. I think that it is related with my below variable.

      LET varMinDate = Num(Peek('TARIH', 0, 'zrapor_genel.xls'));

      Because it only catch "08.06.2002" date as a minimum TARIH value but it is not the minimum one.

      I'm looking for your great support.

      Best Regards,

       

      Asim Akin