calculating 12 months prior

I need some help calculating a begin date.  The user enters the end date - say they enter 4/30/2013.  I was the begin date to be the first of the month 12 months earlier - 5/1/2012.  Is there any clever way to do this experts?
Who is Participating?
Ido MilletConnect With a Mentor Professor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
DateSerial(Year({your_date}), Month({Your_Date}) - 11, 1)
mlmccConnect With a Mentor Commented:
SImilar would be

DateSerial(Year({your_date}) - 1, Month({Your_Date}) + 1, 1)

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.