Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   Day function to remove weekend dates? (http://www.go4expert.com/forums/day-function-remove-weekend-dates-t12524/)

FunkyAnt13 28Jul2008 20:09

Day function to remove weekend dates?
 
I have been asked to prevent dates that fall on the weekend from being inputted into the database, however i have no idea how to do this?

can anyone help?

thanks

apr pillai 18Dec2010 16:30

Re: Day function to remove weekend dates?
 
Use the WeekDay() Function to find out the weekend day.

? WeekDate(Cdate("18/12/2010")
Result: 7
if the result is seven then it is weekend day. (Sun=1, Mon=2,Tue ......Sat=7)

apr pillai 18Dec2010 16:31

Re: Day function to remove weekend dates?
 
Correction:

? WeekDay(Cdate("18/12/2010"))


All times are GMT +5.5. The time now is 17:40.