Showing financial years

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Hi,
I got this formula off a previous posting, which shows
financial year.

FinYr: Year(DateAdd("m",-3,[DatePaid]))

What I need the formula to do is to return the actual
financial years that a payment relates to.

For example, if an invoice was paid on 11/02/2003 the
formula only returns 2003. What I need the formula to
show is 2002/2003, as these are the relating financial
years (01/04/02-31/03/2003) and 2003 on its own could be
interpreted being paid in 2003/2004 - if you catch my
drift.

I'm unable to solve it myself so would be glad of some
help from the experts.

Thanks
Tony
 
FinYr: IIf(Month([DatePaid])<=3,Year([DatePaid])-1 & "/" &
Year([DatePaid]),Year([DatePaid]) & "/" & Year([DatePaid])+1)


Does this do the trick?

-Raoul
 
Raoul,

Perfect - thanks very much

Tony
-----Original Message-----
FinYr: IIf(Month([DatePaid])<=3,Year([DatePaid])-1 & "/" &
Year([DatePaid]),Year([DatePaid]) & "/" & Year([DatePaid]) +1)


Does this do the trick?

-Raoul


Tony said:
Hi,
I got this formula off a previous posting, which shows
financial year.

FinYr: Year(DateAdd("m",-3,[DatePaid]))

What I need the formula to do is to return the actual
financial years that a payment relates to.

For example, if an invoice was paid on 11/02/2003 the
formula only returns 2003. What I need the formula to
show is 2002/2003, as these are the relating financial
years (01/04/02-31/03/2003) and 2003 on its own could be
interpreted being paid in 2003/2004 - if you catch my
drift.

I'm unable to solve it myself so would be glad of some
help from the experts.

Thanks
Tony
Click to expand...
.
Click to expand...
 
Back
Top