Day function to remove weekend dates?

FunkyAnt13's Avatar, Join Date: Jul 2008
Newbie Member
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's Avatar, Join Date: Dec 2010
Go4Expert Member
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's Avatar, Join Date: Dec 2010
Go4Expert Member
Correction:

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