Adding 10 weeks to a date in MS Access 2000
Thread Starter
Join Date: Aug 2001
Location: Berkshire, United Kingdom
Posts: 28
Likes: 0
Received 0 Likes
on
0 Posts
Adding 10 weeks to a date in MS Access 2000
Does anyone know how you can add a number pd days/weeks/months/years etc to a date in Access. i.e. how do you make a query to add two weeks to an already inputtued date in a table.
Any help much appreciated
Michael Fuller PAFP. [email protected]
Any help much appreciated
Michael Fuller PAFP. [email protected]
Guest
Posts: n/a
Michael,
The function you use is DateAdd. Check the help re this but basically.
Dateadd("X",Y,Z)
X is the interval => s-seconds n-minutes (!!!). .d-days,w- weekdays (!!!),ww-weeks, m-months,y-year
Y is the number of intervals (can be negative). .Z is the date you want to change.
If you just want a query to output this, just type in the the Field Dateadd("x",Y,Z) and make Z the field you want to add the interval to ..ENCLOSED in square brackets[field1].
If you want update the data use an update query
Be very careful!!. .Enter the formula as above in the "update to" field of the field you want to change.
Make sure that your Criteria is correct before running the Query.
MAx
The function you use is DateAdd. Check the help re this but basically.
Dateadd("X",Y,Z)
X is the interval => s-seconds n-minutes (!!!). .d-days,w- weekdays (!!!),ww-weeks, m-months,y-year
Y is the number of intervals (can be negative). .Z is the date you want to change.
If you just want a query to output this, just type in the the Field Dateadd("x",Y,Z) and make Z the field you want to add the interval to ..ENCLOSED in square brackets[field1].
If you want update the data use an update query
Be very careful!!. .Enter the formula as above in the "update to" field of the field you want to change.
Make sure that your Criteria is correct before running the Query.
MAx
Thread Starter
Join Date: Aug 2001
Location: Berkshire, United Kingdom
Posts: 28
Likes: 0
Received 0 Likes
on
0 Posts
Thanks alot i will give that a try. I was sure that there must have been a function in access to do what i wanted, it is just a matter of knowing what it is.
Michael
Michael