Date Calculation ?

techexpressinc

Registered User.
Local time
Today, 04:41
Joined
Nov 26, 2008
Messages
185
I have a date and a number of days in the future from the date.

I need to display what that date will be:

i.e.
I have the Start-Date 05-29-09

I need to show the completion date:
i.e.
+ 90 days = 08-27-09

I know the +90 but not the 08-27-09.

How can I do this in Access?

Thank you
Russ
 
You can use the DateAdd() function to display the date 90 days out.
 
Found it a use a expression with a function like this. GREAT!

Expr1: DateAdd("d",90,[DateofConsent])
 

Users who are viewing this thread

Back
Top Bottom