Setting a simple variable

[samvile18]

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?

[vijay_iitkgp · Accepted solution]

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

[samvile18]

Thanks for the help Vijay, this was my next test and it works brilliantly.