Using Dateadd to find a due date

[misha8765]

Thank you in advance for your time.

I have a field called "Hiredate"
Three months after the employees hire date they are off probation.

Based on the hiredate field, I want to run a report showing me who completes their probation within the next week.

Any ideas?

Thank you!

 

[AlexCuse]

where dateadd("m", 3, HireDate) BETWEEN Date() AND dateadd("d", 7, Date())

Alex

A wise man once said
"The only thing normal about database guys is their tables".