DateDiff function

[RL]

I am trying to work out the number of days between two dates, EXCLUDING
WEEKENDS to monitor our order order turnaround time.

I am using the datediff funtion with "w" as the interval, which the help
files describes as weekday intervals.

However, it appears to be giving me the intervals in weeks.

Have I misinterpretted how the function works or is there a bug? Do you know
of an alternative or a workaround to achieve what I am after?

Many thanks
RL

 

[Allen Browne]

DateDiff() with "w" will give a difference in week numbers. Not what you
asked for.

This might help:
Doing WorkDay Math in VBA
at:
http://www.mvps.org/access/datetime/date0012.htm

It does involve some coding (copy'n'paste), and then you can use the
functions just like DateDiff() and the built-in ones.

 

[Darmahart]

Use "d" as the interval. D stands for days.

 

[RL]

Perfect. Thank you very much.

DateDiff() with "w" will give a difference in week numbers. Not what you
asked for.

This might help:
Doing WorkDay Math in VBA
at:
http://www.mvps.org/access/datetime/date0012.htm

It does involve some coding (copy'n'paste), and then you can use the
functions just like DateDiff() and the built-in ones.