Date query

[cornishteeth]

I have dates in a table that correspond to instructors dates of transfer. I need to create a query that pulls up all instructors that are leaving with dates 30 days prior to the date in the field. For example if an instructor has a transfer date of June 18. I want the query to pull the instructor up on May 18. Hope this makes sense.

Thanks,
Frank

 

[Cbrine]

Take a look at MSAccess Function called DateDiff(). It should fit the bill for your problem

HTH
Cal

 

[cornishteeth]

From what I understand and looking at the material, DateDiff takes the difference between two dates. I have one date. If the date is December 7th like today and an Instructor transfers on January 6th, I want his name to appear as a loss of an instructor utilizing a query.

Frank

 

[cornishteeth]

30DaysPrior: DateDiff("d",Date(),[InstructorXferDate]) and put <30 in the criteria. Thanks for the help.

Frank