Date diff trouble

[Cran29]

Expr1: DateDiff("d",[DateFrom],[DateTo]) Can any one please explain why when i use this expression it does not count the starting date. I have a field in my callender called [IsWeekDay] how would i include this to enable it to only count weekdays betwen the dates.

[William McKinley]

Expr1: DateDiff("d",[DateFrom],[DateTo]) Can any one please explain why when i use this expression it does not count the starting date. I have a field in my callender called [IsWeekDay] how would i include this to enable it to only count weekdays betwen the dates.

DateDiff isn't set up to include the start date. Attaching a +1 to the end of your function will add an additional day to the count.

DateDiff("d",[DateFrom],[DateTo])+1

I don't believe that Access has a Weekday count function, but it can be achieved through VBA. See article below:

http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

[Cran29]

I have a field in my callender called IsWeekday to enable me to identify weekdays how would I add this to the expression. Or would I need to do another query before addin the date diff part

[William McKinley]

I have a field in my callender called IsWeekday to enable me to identify weekdays how would I add this to the expression. Or would I need to do another query before addin the date diff part

I recommend using the Weekdays() function detailed in the article I posted previously. It works great!