4 Replies Latest reply: Mar 5, 2012 4:19 AM by jacq . RSS

    Last 1 date is not retrieving

      Hello,

       

      I'm trying to retrive the last one date data only. But i'm not able to retrive it. Can anyone help me.

       

      Code which i'm using is

      Temp_CT_VQDIndividual:

      LOAD Date

      FROM

      Date.xls

      (biff, embedded labels, table is Sheet1$);

       

       

      IndividualMaxDate:

      Load Max(Date) as MaxDate

      Resident Temp_CT_VQDIndividual;

       

      Let vIndividualMaxCapDate=Peek('MaxDate',-1,IndividualMaxDate);

       

       

      DROP Table IndividualMaxDate;

      DROP Table Temp_CT_VQDIndividual;

      T1:

      LOAD Date

      FROM

      Date.xls

      (biff, embedded labels, table is Sheet1$)

      Where

      Date > Date($(vIndividualMaxCapDate)-(1))

      ;

       

       

      Here i'm attaching my file it may helps u.