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
------------------------------
  • 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
    ------------------------------

2 Replies

  • 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
    ------------------------------
    • GraniteHomes's avatar
      GraniteHomes
      Qrew Cadet
      thank you Coach!

      ------------------------------
      GH GH
      ------------------------------