datediff function in query

[LeesKeys]

I have query which I need to run once a year on July 1. The query is set up to compute the difference in months between the client's birthdate and July of the current year. The criteria is that the result is greater than 59. I want to make this query easier for the average employee to run by allowing them to enter the july 1 date when the query opens, rather than having to go into design mode and manually change the date. I've set up plenty of "enter parameter" queries in the past but have no idea how to accomplish this when the datediff function is involved.

[ranman256]

age: DateDiff("m",[dob],[Enter Date])

if you want it for the client,
DateDiff("m",[dob],Date())

[pbaldy]

You can do the same thing, use

[Enter date]

there, or whatever the appropriate text is.

[LeesKeys]

so simple! thanks!!