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.