Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Difference (Access 97)

    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.

  2. #2
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 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>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •