Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Afternoon everyone,
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:
Table1:
Load Distinct
Max([Extract Date]) as MaxDate
From/Resident Table;
Let vMaxExtractDate=Date(Peek('MaxDate',0,'Table1'));
Hope this will help
Please do like:
Table1:
Load Distinct
Max([Extract Date]) as MaxDate
From/Resident Table;
Let vMaxExtractDate=Date(Peek('MaxDate',0,'Table1'));
Hope this will help
Thanks for the help Vijay, this was my next test and it works brilliantly.