Forum Discussion

GraniteHomes's avatar
GraniteHomes
Qrew Cadet
5 years ago
Solved

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 ------------------------------
  • MarkShnier__You's avatar
    5 years ago
    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
    ------------------------------