sequential dates

M

Mary

Hi-
I am building a db and I need to calculate from today's date and add 14 days
for 11 instances. For example, today is 8/17/07 next box I want to
automatically calculate and add 14 days and the next box at 14 days to that
and so on.

Please Help!
Thanks
 
G

George Nicholson

= DateAdd("d", 14, Today())

or, since 1 Day = 1

= Today() + 14

Any valid date reference can be substituted for Today().

HTH,
 
K

KARL DEWEY

George I think you will find that 'Today' is for Excel but Date() is for
Access.
 
G

George Nicholson

you are (of course) right.

Oddly enough I was thinking Now() where I used Today() anyway :)
(which would also be wrong but for a different reason)
 
Top