GraniteHomes
6 years agoQrew Cadet
Custom Data Rule - Restrict Weekends
Hello,
Does anyone know if a custom data rule can stop a user from selecting a date that is on a Weekend?
Thanks
------------------------------
GH GH
------------------------------
Does anyone know if a custom data rule can stop a user from selecting a date that is on a Weekend?
Thanks
------------------------------
GH GH
------------------------------
- Sure
 You can make this rule
 IF(
 DayOfWeek([my date field])=6
 or
 DayOfWeek([my date field])=0,
 "Please select a week day date, weekends not permitted")
 Then you will need to enable Custom Data Rules on the table under Advanced Properties.
 ------------------------------
 Mark Shnier (YQC)
 Quick Base Solution Provider
 Your Quick Base Coach
 http://QuickBaseCoach.com
 mark.shnier@gmail.com
 ------------------------------