topic Re: Date in QlikView

Date

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

HI All ,

Can someone please explain me how do we get the minus of two dates with an example ? ( Differance of two dates )

Thanks

qlikview979 — Tue, 23 May 2017 07:04:38 GMT

Interval(Enddate-Startdate)

qlikview979 — Tue, 23 May 2017 07:15:29 GMT

Do like this

Source:-

T1:

LOAD Startdate,

Enddate,

num(Interval(Enddate-Startdate)) as Difference

FROM

(ooxml, embedded labels, table is Sheet2);

Result:

Startdate Enddate Difference

1/1/2017 1/10/2017 9

1/25/2017 1/30/2017 5

Anil_Babu_Samineni — Tue, 23 May 2017 07:18:57 GMT

Why can't try from your end with 2 fields like Start Date and End Date. And do simple minus operation then look how value looks like

antoniotiman — Tue, 23 May 2017 07:21:19 GMT

Hi John,

assume

SET DateFormat='DD/MM/YYYY';

In Text Object

='01/01/2017'-'15/10/2016' -> 78

=Date(('01/01/2017')-('15/10/2016'),'MM-DD') -> 03-18

Regards,

Antonio