finance date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how can i set the date to show on financial years. I cannot believe this is
not a function already waiting to use. can anyone help???
Thanks
kate
 
Since every company has a different definition of financial year, it's not
really practical to have a built-in function.

What is your definition of financial year? (our company's is Jan 1 to Dec
31)
 
Figure out the day-of-year range where the fiscal year is > year
Ours, for example is 274 - 365 (10/1 - 12/31)
Let bDate be the beginning and eDate be the end of this range; date is the
date being processed

IIF((DatePart("y",date) >= bDate & DatePart("y",date)<= eDate),
DatePart("yyyy",date) +1, DatePart("yyyy",date))
 
You'll need to do something like what Bruce suggested, or use DateAdd to
subtract 3 months from the date when calculating things.
 
Back
Top