Learning123
New member
- Local time
- Today, 00:58
- Joined
- Jan 4, 2009
- Messages
- 9
Hi,
I am creating a bookings database. I need to stop people from making a booking on Mondays.
Does anyone know how to make a validation rule stopping people from booking on Mondays in the Date field?
I am thinking that I need to have a Day field, where the Weekday number (1,2,3, etc) is updated according to the date entered in the Date field (and then validation on that field can be entered to stop the number "2" being entered) - but I have no idea how to do this.
Would be grateful for any help as time is running fast! Thanks
I am creating a bookings database. I need to stop people from making a booking on Mondays.
Does anyone know how to make a validation rule stopping people from booking on Mondays in the Date field?
I am thinking that I need to have a Day field, where the Weekday number (1,2,3, etc) is updated according to the date entered in the Date field (and then validation on that field can be entered to stop the number "2" being entered) - but I have no idea how to do this.
Would be grateful for any help as time is running fast! Thanks