topic Re: How to compare if the 2 dates are the same? in QlikView

How to compare if the 2 dates are the same?

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

Hi,

I am trying to get a total count of 2 columns of dates to find out if they are the same.

Date Account Created vs Date of Booking (those dates that are the same)

How do I go about getting it?

Thanks!

Re: How to compare if the 2 dates are the same?

PrashantSangle — Fri, 18 Aug 2017 11:51:04 GMT

Sum(If(date2=date1,1,0))

Regards,

Re: How to compare if the 2 dates are the same?

sunny_talwar — Fri, 18 Aug 2017 11:52:49 GMT

May be create a flag in the script

If([Date Account Created] = [Date of Booking], 1, 0) as DateMatchFlag

Re: How to compare if the 2 dates are the same?

its_anandrjs — Fri, 18 Aug 2017 11:55:39 GMT

On front end you calculate or in the backend you need to compare this dates.

Regards

Anand

Re: How to compare if the 2 dates are the same?

its_anandrjs — Fri, 18 Aug 2017 12:00:42 GMT

On front end if you calculate then try with

On Front End:-

Sum( If( Date Account Created = Date of Booking, 1 , 0 ) )

On Script Part:-

Load

if( Interval ( [Date of Booking] - [Date Account Created] , 'D hh:mm') = 0,1 , 0) as DateDiff

From Location;

Regards,

Anand

Re: How to compare if the 2 dates are the same?

sunny_talwar — Fri, 18 Aug 2017 12:02:41 GMT

Hey Anand -

What is the point of adding interval function to create a flag?? Am I missing something here

Re: How to compare if the 2 dates are the same?

Anonymous — Fri, 18 Aug 2017 13:09:46 GMT

Thank you!

Re: How to compare if the 2 dates are the same?

Anonymous — Fri, 18 Aug 2017 13:10:04 GMT

Thank you!

Re: How to compare if the 2 dates are the same?

its_anandrjs — Fri, 18 Aug 2017 15:43:45 GMT

Hi Sunny,

We can use simple IF also here which is also fine this i explain if we have hour and minutes difference then we calculate with the interval .

Regards,

Anand

Re: How to compare if the 2 dates are the same?

sunny_talwar — Fri, 18 Aug 2017 15:46:16 GMT

Even if we have hours and minutes, we don't necessarily need Interval, right? Interval is just a formatting function... the underlying value is a number... so if you compare the number of formatted number, it should not make a difference

Re: How to compare if the 2 dates are the same?

its_anandrjs — Fri, 18 Aug 2017 16:26:25 GMT

Its just representation, Cheers Sunny

Regards

Anand