View Single Post
  #2  
Old January 7th, 2010, 03:50 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default Count Only Weekday in the DateDiff Function

http://lmgtfy.com/?q=access+work+day+function

--
Duane Hookom
Microsoft Access MVP


"phm" wrote:

Hello,
I have a report where the following function counts the interval of days
between two dates. This is one of the actual formulas being used:

=DateDiff("d",[to_plm],[from_plm])

Now, I need to adjust this syntex so that only the weekdays, workdays, are
counted. Please help!
--
phm