Finding oldest date in script

[#1]

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?

[giakoum]

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