Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
you can find the different by converting the date fields to numbers by using max(date(Enddate))-min(date(Startdate))
interval(max(Enddate)-min(Startdate))
Hi,
You can use this formula,
=Num(Max(Date(Date,'DD/MM/YYYY'))- Min(Date(Date,'DD/MM/YYYY')),'###')
Interval(Max(EndDate)-Min(StartDate),'dd')