Munipulate current date

[Daniel]

I am trying to set criteria on a Date/Time field that is 1
year ago from the current date.

If today is 15/12/03 this should calculate to 15/12/02

I can do this with the following, but is there a simpler
way to do it?

Day(Now()) & "/" & Month(Now()) & "/" & Year(Now())-1

Regards,

Daniel

 

[Duane Hookom]

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