Roffee wrote:[color=blue]
> Hi.
>
> I'm a bit confused about date functions in Access. I need the program to
> calculate a new date that lays 15 days ahead of a given date in a table. I
> studied the datediff function, but as I see it, it only returns a number of
> days (or other time period) between two dates. I need a future date as
> output.[/color]
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
It might be that you're trying to use a function that will not give you
the correct results. Try reading the Access VBA Help article on
"DateAdd Function." Basically, to get 15 days ahead of a specific date:
NewDate = DateAdd("d", 15, SpecificDate)
Or you can do this
NewDate = SpecificDate + 15
The "d" is an interval indicator. Various others are:
d = day
y = day of year
yyyy = year
q = quarter
m = month
w = weekday
ww = week
h = hours
n = minute
s = second
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQm6lBoechKqOuFEgEQL/FwCaAxkVTmNBD8qiPGCNcgXE2k4A3OAAn1FY
Qtsa9BNYKPwU8YX3Wu0uPvuX
=e4pc
-----END PGP SIGNATURE-----
