How to make time calculation

[amator]

Hi.
I'am trying to count: todays date -12 month.
So how I tell access that I want answer which date is year from this date?
Or how I must "write" 12 months in SQL?

 

[ColinEssex]

Access help has the answer under DateAdd()

= DateAdd("yyyy", 1, [YourDate])

Col

 

[Big Pat]

Thank you

Access help has the answer under DateAdd()

= DateAdd("yyyy", 1, [YourDate])

Col

I'm not the user who posted this question, but I want to say thank you anyway. I've been trying to come up with a reliable way to query "the last 2 years" in a database where everythying is applied to the first of a month and your tip helped me to come up with DateAdd("m",-23,[LatestDate]) which solves my problem.