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.
Date.qvw 131.8 K
Here you go, solution attached. Essentially your need to add a date(floor(Date)) around the variable.
Hope this helps. Have a good weekend!
Date.qvw 223.2 K
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
(biff, embedded labels, table is Sheet1$);
Load Max(Date) as MaxDate
DROP Table IndividualMaxDate;
DROP Table Temp_CT_VQDIndividual;
(biff, embedded labels, table is Sheet1$)
Date > Date($(vIndividualMaxCapDate)-(1))
Here i'm attaching my file it may helps u.