Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI I have script as below and I only want to pick one date ie whichever is latest so I gave max(Date) in where clause.
Load
ID,
Date
From
[Soure]
WHERE Date = Max(Date);
This is not working
My Date format is as follows ; 2015-12-01 00:00:00
Thanks Much
MaxDate:
Load
Max(date) as MaxDate
From
[Source]
;
Let vMaxDate=Date(Floor(Peek('MaxDate',0,'MaxDate')));
Load
ID,
Date
From
[Soure]
WHERE Date(Floor(Date))='$(vMaxdate)'
;