Date where clause in load script

[apthansh]

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

[sasiparupudi1]

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)'

;