I want to remove last Date records from Table Dynamically
Here I need to remove 03/01/2016. I need to do this dynamically why because after some time the date may be change. Guys can u please help me on this
Thanks & Regards
have you tried
Can you tell us what is the purpose of removing last date ? Do you want to achieve it from front end or back end?
Try like this
Max(Date) AS Date,
1 AS Flag
WHERE Flag <> 1;
DROP TABLE Temp;
Hope this helps you.
I think you need:
WHERE Flag <> 1 Or IsNull(Flag);
WHERE Flag <> 1 alone is good enough here. Am I missing something? The Isnull() would be implicit here.
I though QV was like SQL here; but I tested this scenario and you are quite correct. Keep on learning
Max(Date) as MxDate
let vMaxDate = peek('Date', 0,'Temp');
Drop table Temp;
Where Date < $(vMaxDate);
Try this -
Load * inline [
Let vLast = FieldValue('Date',NoOfRows('t1'));
DROP Table t1;
Max(Date_Field ) as Latest_Date
where Date_Field <> max(Date_Field);
Retrieving data ...