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

    Last 1 date is not retrieving

    jacq .

      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.