I'd like to set a variable in my script called vMaxExtractDate...I basically need the value to be the maximum date with the field Extract Date, this is what I have so far and the value is always blank:
SET vMaxExtractDate = Max(Date([Extract Date]))
Can anyone help me please?
Please do like:
Max([Extract Date]) as MaxDate
Hope this will help
Thanks for the help Vijay, this was my next test and it works brilliantly.
Retrieving data ...