access 2002 I need to cal the end date for a 36 or 48 month lease?

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

Guest

I have a starrting date and need to add either 36 or 48 months the year. So
if I had 03/01/2005 in my start date field I neeto place 03/01/2009 in the
end date field for 48 months!
or 03/01/2008 for 36 months in the end date field.
I need to do this in a query!
 
The best way to do it is by using days instead of years if you are restricted
to using a query.

In your update cell [TableName]![StartDate] + 1461 for four years.

You can also use an IIF in the decision box, but that can be very tricky
unless you are familar with it.


Len
 
DateAdd("m", 36, Now())
returns
5/9/2008 5:14:31 PM (i.e., 36 months from today)

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"date calc in query in access 2002" <date calc in query in access
(e-mail address removed)> wrote in message
news:[email protected]...
 
Pardon me, but I certainly don't agree that's the "best way".

Use the DateAdd function with exactly what's wanted:

DateAdd("m", 36, [TableName]![StartDate]) or DateAdd("m", 48,
[TableName]![StartDate])



--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Len said:
The best way to do it is by using days instead of years if you are
restricted
to using a query.

In your update cell [TableName]![StartDate] + 1461 for four years.

You can also use an IIF in the decision box, but that can be very tricky
unless you are familar with it.


Len

date calc in query in access 2002 said:
I have a starrting date and need to add either 36 or 48 months the year.
So
if I had 03/01/2005 in my start date field I neeto place 03/01/2009 in
the
end date field for 48 months!
or 03/01/2008 for 36 months in the end date field.
I need to do this in a query!
Click to expand...
Click to expand...
 
Back
Top