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
|
|||
|
|||
Counting dates
What formula within a query do you use to count dates, i.e. 5/1/09 through
6/4/09 for example....???? -- Beth McLaren |
#2
|
|||
|
|||
Counting dates
DateDiff("d", #5/1/2009#, #6/4/2009#) will return the number of days
(I'm assuming you want days). Assuming your data is actually in table fields; DateDiff("d", [Field1], [Field2]) If you want to include the second field in the returned result you'll have to add one; DateDiff("d", [Field1], [Field2]) + 1 -- _________ Sean Bailey "Beth McLaren" wrote: What formula within a query do you use to count dates, i.e. 5/1/09 through 6/4/09 for example....???? -- Beth McLaren |
Thread Tools | |
Display Modes | |
|
|