Forum Discussion

DarleneDarlene's avatar
DarleneDarlene
Qrew Member
12 years ago

How do you calculate the Last Day of the Fiscal Year?

Our fiscal year is May 1st through April 30th each year. Based on the "Start Date" of a piece of work, I would like to calculate the last day of the Fiscal Year. e.g. For Start Date 1-Feb-2013, E...
Tables and fields
GeorgeBramhall1's avatar
GeorgeBramhall1
Qrew Member
6 years ago
What's wrong with this formula? Trying too produce a year end date in the year my [Bound Date] is in is in. Also another formula needed for the end date of the following year that the [Bound Date] is in
var number YYYY = If(Year([Bound Date])=Year(Today), Year(Today)+1,Year(Today)+1);Date($YYYY,12,31) I am sure this is a more complicated formula than I need.