Search results

Solved Thanks for introducing the DateDiff expression. I finally worked it out. I created a new column with this in the field row: Expr1: DateDiff("m",[event_date],Now()) Then in criteria set >6 That shows everything that has a month difference greater than 6 between todays date and the...

Thanks Thanks very much, that automates it for me at least. Is there definitely no way to make it use months instead of days? If not I will have to filter out the results I don't want.

Is there an expression to show records in a query that are older than 6 months? At the moment I have to go into the database every month and change the criteria date ie: <#01/09/2007# It would be much easier if it could do this automatically with an expression. Can anyone tell me if ones...