Help! Need an Invoice Calculation

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

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
 
Jill said:
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.
Click to expand...


Try using:

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