Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for
Did you mean:
Creator III

## 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

1 Solution

Accepted Solutions
MVP

May be this

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

9 Replies
MVP

May be this

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

Creator III

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

Creator III

Hi Elizabeth,

How about using set analysis. Maybe something like:

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

Thanks,

Carlos

Creator

Hello Carlos

i thought about the same thing

Creator III

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]))

MVP

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

Specialist

I think

Count(If([Work Date] - [Call Date] > 1, 1))

asuming 24 hrs

Creator III
Author

Thank you

Creator III
Author