Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have three different fields I have loaded in the script, with each field containing only one date:
Dates:
Date1,
Date2,
Date3
How can I find the the oldest of these dates in the script?
concatenate the 3 fields into one table and field and then :
[test]:
LOAD * INLINE [
F1
2012/05/20
2012/05/10
2012/05/05
];
[test1]:
first 1 LOAD
F1 as F2
Resident [test]
Order By F1 asc;
F2 is your answer