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

    Selecting the later date from 3 date fields



      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.