Issue Date Formula = EDATE(StartDate,-12)
I.e. 04/01/07 Start Date, want to see 04/01/06
This formula returning a #REF! and doesn't calculate.

If I try EOMONTH(StartDate,-12) it returns 04/30/06 which works but incorrect date.

Can you please suggest a date formula (Excel or Jet Reports) to do this? The Report is for a balance sheet.
=DATE(YEAR(StartDate)-1, MONTH(StartDate), DAY(StartDate))
=DATE(YEAR(StartDate), MONTH(StartDate) -12, DAY(StartDate))