Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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

Tags (3)
1 Solution

Accepted Solutions
Not applicable

Re: Selecting the later date from 3 date fields

Hi,

Try with this:

Date(RangeMax(EffectiveLossDate, EntryDate, IncepDate), 'DD-MM-YYYY')

Regards,

Ricardo

2 Replies
Not applicable

Re: Selecting the later date from 3 date fields

Hi,

Try with this:

Date(RangeMax(EffectiveLossDate, EntryDate, IncepDate), 'DD-MM-YYYY')

Regards,

Ricardo

MVP
MVP

Re: Selecting the later date from 3 date fields

Hi,

Try like this

=Date(RangeMax(Date#(Max(EffectiveLossDate),'YYYY/MM/DD')  , Date#(Max(EntryDate), 'YYYY/MM/DD'), Date#(Max(IncepDate), 'YYYY/MM/DD')), 'DD-MM-YYYY')

Hope this helps you.

Regards,

Jagan.

Community Browser