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
Subtracting two cell dates and highlight if over due by a certain amount of days 0
IF satement fo in between dates 0
IIf expression 0
Conditional format and comparing dates 1
Date Difference 4
Calculating the difference, in hours, between two date/time in two different time zon 2
calculations in report controls 2

Top