Help! Need an Invoice Calculation

[Guest]

Hi

I'm trying to put an Invoice report together and am stuck on a calculation/formula. Any suggestions on what I could inpout for the following

"effective date with current year to effective date the next year minus a day
Effective date is 2/4/0
I need it to read this year's invoice as 2/4/2003 to 2/3/2004

Thanks for any help!!!
Jill

 

[Marshall Barton]

I'm trying to put an Invoice report together and am stuck
on a calculation/formula. Any suggestions on what I
could inpout for the following:

"effective date with current year to effective date the next year minus a day"
Effective date is 2/4/01
I need it to read this year's invoice as 2/4/2003 to 2/3/2004.

Try using:

DateSerial(Year(Date),Month(EffectivDate),Day(EffectivDate))
& " to " &
DateSerial(Year(Date)+1,Month(EffectivDate),Day(EffectivDate)-1)