Oct 5, 2003 #1 rene1000 IS-IT--Management Apr 9, 2002 89 NL i have a textbox in which dates are entered. on the afterupdate event i would like to check if the date entered is on a weekend. how can i do this ?
i have a textbox in which dates are entered. on the afterupdate event i would like to check if the date entered is on a weekend. how can i do this ?
Oct 5, 2003 1 #2 danvlas Programmer Jul 30, 2002 2,446 RO IsWeekEnd= (Left(Format(YourDate,"ddd", 1) ="S" Good luck Daniel Vlas Systems Consultant http://www.geocities.com/danvlas/AutoMail.html Upvote 0 Downvote
IsWeekEnd= (Left(Format(YourDate,"ddd", 1) ="S" Good luck Daniel Vlas Systems Consultant http://www.geocities.com/danvlas/AutoMail.html
Oct 5, 2003 Thread starter #3 rene1000 IS-IT--Management Apr 9, 2002 89 NL It works great Daniel. Thanks ! Upvote 0 Downvote