topic Re: difference between two dates. in QlikView

difference between two dates.

warrentk80 — Fri, 24 Apr 2015 07:08:24 GMT

Goodmorning everyone

I need to calculate the difference between two dates.

there is a native function in QlikView?

Thanks for collaboration

Andrea

Re: difference between two dates.

fvelascog72 — Fri, 24 Apr 2015 07:11:39 GMT

Try Interval() function.

Re: difference between two dates.

manojkulkarni — Fri, 24 Apr 2015 07:13:42 GMT

try

fabs(Date(Field1,'DD/MM/YYYY')) - fabs(Date(Field2,'DD/MM/YYYY'))

Re: difference between two dates.

jonathandienst — Fri, 24 Apr 2015 07:17:46 GMT

Dates are numeric values in days, times are fractions of a day, so:

=Date1 - Date2 // will give number of days (including fractional amount for the time difference if any

=Floor(Date1) - Floor(Date2) // number of days disregarding time differences

Also

=(Date1 - Date2) * 24 // differences in hours

=(Date1 - Date2) * 24 * 60 // differences in minutes

Interval() can format the day and time differences

=Interval(Date1 - Date2, 'dd hh:mm') // displays time differences in hh:mm format

HTH

Jonathan

Re: difference between two dates.

jonathandienst — Fri, 24 Apr 2015 07:23:41 GMT

Manoj K wrote:

fabs(Date(Field1,'DD/MM/YYYY')) - fabs(Date(Field2,'DD/MM/YYYY'))

Date() is a formatting function - it does not affect the value. If Field1 and Field2 are dates, then Date() here will do nothing except waste time. If Field1 and Field2 are strings, then you should use Date#() which is the date interpretation function.

Dates would not usually be negative (unless they are before 31 December 1899), so fabs() will also not do anything useful here.

So if the values are dates, then that expression is the same as =Field1 - Field2