Greater than 1

[withoutwax]

I would be grateful for any help. We have a database of members and each contact has a date field telling us when their details were last updtaded. I want to pull out all our contacts that have not been updated for over a year. I am doing this via a query and am looking for the formula to be entered in the criteria field for 'date updated'. Thank you in advance.

 

[PHV]

<DateAdd("yyyy",1,Date())

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PWise]

should it not be <DateAdd("yyyy",-1,Date())

 

[PHV]

Good catch PWise !