Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
marksmunich
Creator III
Creator III

find the difference of dates

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.

4 Replies
Yousef_Amarneh
Partner
Partner

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

Yousef Amarneh
MarcoWedel

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

venkatasreekant
Specialist
Specialist

Hi,

You can use this formula,

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

MK_QSL
MVP
MVP

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