9 Replies Latest reply: Feb 5, 2018 10:28 AM by Elizabeth Viso

# Counting the differences between two dates greater than 24

Hello,

I have two dates/;

Call Date & Work Date, I want to count the days between those two days that are greater than 24. I tried this:

(Count([Call Date] - [Work Date])) > 24 but that is not working

Thank you

• ###### Re: Counting the differences between two dates greater than 24

May be this

Sum(If([Call Date] - [Work Date] > 24, 1, 0))

• ###### Re: Counting the differences between two dates greater than 24

Date1-Date2  will give you the difference in days, so you simply have to wrap it in the statement Sunny wrote above.

• ###### Re: Counting the differences between two dates greater than 24

Hi Elizabeth,

How about using set analysis. Maybe something like:

count(<{NetWorkDays([Call Date], [Work Date]={"> 24"}>},NetWorkDays([Call Date], [Work Date]))

Thanks,

Carlos

• ###### Re: Counting the differences between two dates greater than 24

Hello Carlos

i thought about the same thing

• ###### Re: Counting the differences between two dates greater than 24

Thanks Fathi,

I just noticed that I am missing a parenthesis in my expression.

Here is the revised code:

count(<{NetWorkDays([Call Date], [Work Date])={"> 24"}>},NetWorkDays([Call Date], [Work Date]))

• ###### Re: Counting the differences between two dates greater than 24

This won't work as you cannot use functions/calculations on the left hand side of a set modifier... you can perform the same calculation in the script to create a field as an alternative