 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2008date difference excluding weekends
Hi, I am trying to write a query that will count the number of days between two dates but exclude weekends from the count. Any help would be greatly appreciated See: Doing WorkDay Math in VBA at: http://www.mvps.org/access/datetime/date0012.htm  SignatureAllen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. > Hi, > > I am trying to write a query that will count the number of days between > two > dates but exclude weekends from the count. Any help would be greatly > appreciated If you don't want to use code, you can calculate in a query Total Days:DateDiff("d",[date field to start from],[date field to end from]) Weekends:DateDiff("ww",[date field to start from],[date field to end from]) Total Weekdays:[Total Days] - ([Weekends]*2) > See: > Doing WorkDay Math in VBA [quoted text clipped - 7 lines] > > dates but exclude weekends from the count. Any help would be greatly > > appreciated Mikedsn - thanks for this info, you've saved me alot of messing about > If you don't want to use code, you can calculate in a query > [quoted text clipped - 13 lines] > > > dates but exclude weekends from the count. Any help would be greatly > > > appreciated Thank you Mikedsn Signature. > Mikedsn - thanks for this info, you've saved me alot of messing about > [quoted text clipped - 15 lines] > > > > dates but exclude weekends from the count. Any help would be greatly > > > > appreciated
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.