Chick this out:
// Make a table just for calcultating the variable:
Order By transaction desc;
//Calculate the variable:
LET varCheck = Peek('Transaction',0);
//We don't need the tble anymore:
DROP Table Check;
IF ($(varCheck)>&(Today())) then
Thanks a lot, it worked.
Why did this not work though?
LOAD date(Transaction) as Transaction
Info (txt, codepage is 1252, embedded labels, delimiter is '\t', msq);
LET CheckDate = Peek('Transaction',0);
LET CheckToday = Today();
DROP Table CheckDate;
IF ($(CheckDate)<=$(CheckToday)) then