Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Sum(If(date2=date1,1,0))
Regards,
May be create a flag in the script
If([Date Account Created] = [Date of Booking], 1, 0) as DateMatchFlag
On front end you calculate or in the backend you need to compare this dates.
Regards
Anand
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
Hey Anand -
What is the point of adding interval function to create a flag?? Am I missing something here
Thank you!
Thank you!
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
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