DateDiff giving same results for "w" and "ww" and both are the same.

[khughes46]

I am trying to count the number of weekdays between two dates using DateDiff: DateDiff("w",[EnrollmentDate],{WithdrawalDate]).


I have an EnrollmentDate of 12/02/2014 and a WithdrawalDate of 12/04/2014. I am expecting a 2 and am getting a 0.
In another I have dates of 08/25/2014 and 04/24/2015 and am getting 34; which obviously can't be right.
What am I missing? Please guide me.

[June7]

"w" parameter does not mean weekday, it means week and "ww" means calendar week.

Counting the weekdays (excluding weekends and holidays) in a date range requires a custom function. Common topic in forum. Here is one https://www.accessforums.net/program...ecs-52457.html