Transactions:
SQL SELECT
trn_uid,
trn_no,
trn_calendarDate,
trn_fiscalDate
FROM transact;
Temp:
load
max(trn_calendarDate) as maxCDate
,max(trn_FiscalDate) as maxFDate
resident Transactions;
LET vMaxCal = peek(‘maxCDate’);
LET vMaxFiscal = peek(‘maxFDate’);
drop table Temp;