![]() |
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 |
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) |
Re: Day function to remove weekend dates?
Correction:
? WeekDay(Cdate("18/12/2010")) |
| All times are GMT +5.5. The time now is 00:23. |