|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))
#REF! on Data Formula Field Print
Modified on: Mon, Dec 12, 2016 at 3:26 PM
Did you find it helpful? Yes NoSend feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.