Difference between two dates if greater than 14

C

CarlaInJax

I am trying to determine the number of days between two fields: [Date Call
Received] and [Date Resolved] but only if the number of days is greater than
14. I've been going insane with this but cannot seem to make it work on
either a query or a report.
Thanks for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number of days between dates if greater than 14 7
Conditional format and comparing dates 1
calculations in report controls 4
Date Difference 4
IF formula 8
Show if null or greater than 13
grouping and sorting - dates and balances 5
Help please with nested iif 2

Top