2 Replies Latest reply: Mar 14, 2013 12:52 PM by jagan mohan rao appala RSS

    Selecting the later date from 3 date fields

      Hello,

       

      I am trying to select the later date from the 3 dates below -

       

      1. EffectiveLossDate

      2. EntryDate

      3. IncepDate

       

       

      I am trying to use the below code, which I wrote myself, but QlikView does not recognise it. Any ideas?

       

       

      Max(date(EffectiveLossDate or EntryDate or IncepDate,'YYYY/MM/DD'),'DD-MM-YYYY') as [Applicable Calendar Date]

       

       

      Many thanks.

      John