Forum Discussion

GraniteHomes's avatar
Qrew Cadet
5 years ago

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
    You can make this rule

    DayOfWeek([my date field])=6
    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