Skip to main content
Solved

Custom Data Rule - Restrict Weekends

  • April 24, 2020
  • 0 replies
  • 71 views
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
------------------------------

Best answer by MarkShnierYou

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement