Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Here you go, solution attached. Essentially your need to add a date(floor(Date)) around the variable.
Hope this helps. Have a good weekend!
Derek
Hi Jacq
Works perfectly fine on mine (see attached). But I did create my own date.xls file, do you have your excel file you can send? I think it may simply be a formatting issue on the date in your excel file we need to handle.
Derek
For your reference i'm attaching my excel file..
Here you go, solution attached. Essentially your need to add a date(floor(Date)) around the variable.
Hope this helps. Have a good weekend!
Derek
Thanks a lot derekjones It's working...
Where
Date(floor(Date)) >= Date($(vIndividualMaxCapDate))
The keyworkd Floor helped us..