find the difference of dates

[marksmunich]

Hallo Qlik community,

I have 2 diferent date fields, I have calculate the max of date field and min of other date field. now the Problem is i want to find the difference between These 2 fields.

for example I am using the following formula, but is not returning the right date.

differencetime=interval((max(Enddate)),(min(Startdate)))

any suggestions.

[Yousef_Amarneh]

you can find the different by converting the date fields to numbers by using max(date(Enddate))-min(date(Startdate))

[MarcoWedel]

interval(max(Enddate)-min(Startdate))

[Anonymous]

Hi,

You can use this formula,

=Num(Max(Date(Date,'DD/MM/YYYY'))- Min(Date(Date,'DD/MM/YYYY')),'###')

[MK_QSL]

Interval(Max(EndDate)-Min(StartDate),'dd')