Dates in an expression

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

Guest

Okay, I'm an idiot. Pretty new to Access. I need to
create an expression that will give me a value of the date
from one field + seven days. I have re-written this every
which way with no luck. Could anyone offer me a tip?
 
=Date()+7

However, you said "field" not "control". This can't be done in a table. It
can be done using a calculated control, such as a textbox, on a form or
report. You shouldn't need to store calculated data since you can calculate
it whenever you need it.

The reason this equation works is because of the way Access/VBA handle
dates. Dates are a floating point number where the whole number portion is
the number of days since 30 DEC 1899 and the decimal portion is the time of
day (example: 1.25 would be 31 DEC 1899 6:00:00 AM). To add together other
units of time you would use the DateAdd function. This function can be used
to add days as well, its just not necessary.
 
Back
Top