DateAdd problem

  • Thread starter Thread starter deb
  • Start date Start date
D

deb

i want to calculate and end date for a lease term

pretty easy =DateAdd("yyyy",+[Term],[StartDate])

so my start date is 01/07/09 and my term is 1 year so my end date is 01/07/10

trouble is, what it should be is 30/06/10

my question is how do i get the above formula to deduct one day to get the
correct date?
 
LOL - now doesnt that make me feel dumb!

i was thinking i'd have a proble because i'd dont the calc in years but i
wanted to deduct one day

thank you so much
--
deb


Allen Browne said:
=DateAdd("yyyy",+[Term],[StartDate]) - 1

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.


deb said:
i want to calculate and end date for a lease term

pretty easy =DateAdd("yyyy",+[Term],[StartDate])

so my start date is 01/07/09 and my term is 1 year so my end date is
01/07/10

trouble is, what it should be is 30/06/10

my question is how do i get the above formula to deduct one day to get the
correct date?
Click to expand...

.
Click to expand...
 
Back
Top