Date Calculation

  • Thread starter Thread starter KP
  • Start date Start date
K

KP

Hi, I hope you are doing well.

I have two dates, Last Reviewed and Next Review Due. I'm
trying to set up query to select records that are within
30, 60 and 90 days of Next Review Date, any help with the
formula would be greatly appreciated.

TIA
 
Check out the DateAdd function. Use it as one of the boundary conditions in
the criterion expression.
 

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

Date Calculation in a query 8
projecting due dates 4
Need Help with Formula Expansion 5
Query for 1st field, if blank then query 2nd field but not both. 6
Countif 3
Extracting Month and day from Date field 2
Excel Formula - Count Dates from another Sheet 8
Pull latest date from Multiple entries 2

Back
Top