If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculate date difference.
How would I calculate the difference between two dates
and, have the calculated difference show up as a value beside each date. I'm thinking I would have to add another column to the table and place a quey for that column. Or is there a built in function within Access that allows me to do this. |
#2
|
|||
|
|||
There is a built in function. You could add a calculated field to a query or
do this in a calculated textbox on a form or report. The functions you want are DateAdd and DateDiff. DateAdd accepts a single date and interval to compute a new date. DateDiff accepts two dates to compute the elapsed time between them. Both have parameters for what the elapsed time should be (days, weeks, years, etc). -- Wayne Morgan MS Access MVP "Charles Harris" wrote in message ... How would I calculate the difference between two dates and, have the calculated difference show up as a value beside each date. I'm thinking I would have to add another column to the table and place a quey for that column. Or is there a built in function within Access that allows me to do this. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to calculate a date 3 yrs on | Kimla | Running & Setting Up Queries | 1 | November 11th, 2004 04:24 PM |
How to calculate time difference? | barton | General Discussion | 4 | July 13th, 2004 05:49 AM |
How to calculate time difference? | barton | General Discussion | 0 | July 12th, 2004 06:31 AM |
How to calculate 12 months from "Date Added" field | Sandi Gauthier | Worksheet Functions | 2 | November 19th, 2003 05:01 PM |