Prev: Filter pivotchart in report
Next: CDO message
From: deb on 22 Dec 2009 21:12
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?


--
deb
From: Allen Browne on 22 Dec 2009 21:16
=DateAdd("yyyy",+[Term],[StartDate]) - 1

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"deb" <deb(a)discussions.microsoft.com> wrote in message
news:760FD230-8CDD-46CB-9374-DFEA99E85523(a)microsoft.com...
> 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?
>
>
> --
> deb

From: deb on 23 Dec 2009 01:13
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" wrote:

> =DateAdd("yyyy",+[Term],[StartDate]) - 1
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
>
> "deb" <deb(a)discussions.microsoft.com> wrote in message
> news:760FD230-8CDD-46CB-9374-DFEA99E85523(a)microsoft.com...
> > 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?
> >
> >
> > --
> > deb
>
> .
>
 | 
Pages: 1
Prev: Filter pivotchart in report
Next: CDO message