Munipulate current date

  • Thread starter Thread starter Daniel
  • Start date Start date
D

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
 
Back
Top