DateDiff function?

[AnnPhil]

what is the correct expression for calculating the date for 3 years from todays date?

 

[DreamGenius]

DateAdd("Y",3,Date)

 

[Brianwarnock]

I think that should be Dateadd("yyyy",3,Date()) according to Help.

 

[AnnPhil]

sorry,I need to calculate 3 years back from todays date

 

[DreamGenius]

DateAdd("YYYY",-3,Date())

 

[AnnPhil]

Thanks that worked great!