I have an expression in a query: TurnarounddaysateDiff("d",[dateassgnd],[datecompleted]). This gives me the number of days between the dates but I need the number of days minus the weekends. I tried NETWORKDAYS(start_date,end_date) but that didn't work. Please help. Thanks in advance.
Results 1 to 2 of 2
Thread: Date Difference (Access 97)
-
5 Star Lounger
- Join Date
- Jan 2001
- Posts
- 1,110
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2001-10-24 10:43Date Difference (Access 97)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
3 Star Lounger
- Join Date
- Mar 2001
- Location
- Minneapolis, Minnesota, USA
- Posts
- 262
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2001-10-24 15:24Re: Date Difference (Access 97)
Behold the wonder of the Access Web! You can call <A target="_blank" HREF=http://www.mvps.org/access/datetime/date0006.htm>this</A> function in a query passing in your begin and end dates.
<font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>
