Results 1 to 2 of 2

Thread: DateAdd("w",1,#1-14-2000#)

  1. #1
    Join Date
    Dec 1969

    Default DateAdd("w",1,#1-14-2000#)

    DateAdd("w",1,#1-14-2000#). This should add one weekday to my date, which is a friday, thus giving me a monday, or 1-17-2000. However, it gives me 1-15-2000. anyone know why?

  2. #2
    Join Date
    Dec 1969

    Default RE: DateAdd(

    Saturday and Sundays are also weekdays.<BR>(So you get the next day 1-15-2000 thats a saturday)<BR><BR>I guess you are considering the function to treat sat and sunday as weekend :-)

Posting Permissions

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