How can I create a report to check if requests are closed before due date?

[Joaquin Campos]

Hi all,

I'm trying to create a report to check if requests are fulfilled before due date.

To do that I need to compare both close and due dates. I can compare both fields but I haven't managed to indicate that due date is just later than due date without having to specify at least a number of hours. As result, even if I indicate 0 hours there's still a possibility that I'm missing records where due date is just some minutes later than closed date.

Isn't there a way to just indicate that something happens before or later than other event without specifiying a specific amount of time?

Thank you in advance:

Joaquín

[Matthew Smith · Accepted solution]

Hi Joaquin

This has had limited testing, but I think you can achieve this by specifying your condition as 'Closed is more than 0 hours before due date'

Hope it helps

Matt

[Joaquin Campos]

Thanks a lot Matt,

I was not sure if it would work in that case.

I also tested this on my side and worked as well.

Thank you!

Joaquín