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

DateAdd("Y",3,Date)

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

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

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

Thanks that worked great!