Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Finding oldest date in script

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?

1 Reply
giakoum
Partner - Master II
Partner - Master II

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