topic Difference between two dates in QlikView

Difference between two dates

Bad_QlikDeveloper99 — Tue, 15 Aug 2023 19:24:58 GMT

Hello everyone,

I´d like to get the difference of two dates in days. I tried the Interval-function, but after using it, the result was only '-'.
I am using the following function:

Interval(V_BelegKopf.Pruefungsdatum - V_BelegKopf.BelegDatum,'D')

Could somebody help me, please?

Re: Difference between two dates

Vegar — Tue, 15 Aug 2023 21:49:43 GMT

It could be that your ...datum fields are not recognised as dates.

Once you ensured that then your expression or just num(V_BelegKopf.Pruefungsdatum - V_BelegKopf.BelegDatum, '0') should give you what you want.

Re: Difference between two dates

BrunPierre — Tue, 15 Aug 2023 22:30:35 GMT

Try

=Floor(Num(V_BelegKopf.Pruefungsdatum - V_BelegKopf.BelegDatum))