Showing financial years

[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

 

[Guest]

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


Does this do the trick?

-Raoul

 

[Tony]

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

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

.