Calculating number of days between dates (Access 2000)

Topic

New Reply

If I have the start date and the end date, how would I calculate the number of days in between, not counting the end date as a day

Reply | Quote

Replies

I’m not sure about Access2K, but it *should* work like A97. Try this:

datediff(“d”,startdate,enddate) for days

datediff(“w”,startdate,enddate) for weekdays (m-f)

Reply | Quote

I’m not sure about Access2K, but it *should* work like A97. Try this:

datediff(“d”,startdate,enddate) for days

datediff(“w”,startdate,enddate) for weekdays (m-f)

Reply | Quote

Chico’s suggestion should work. Or, since dates are stored as a number of days (since December 31, 1899), you can simply subtract them: [End Date] – [Start Date]

Reply | Quote