Due Date cannot be today

Question

Good Morning,
Is there a way to restrict a date field?
So there is a table for Task Z.&nbsp; Dept. A creates new tasks, however, once created the second step in the process is done by Dept. B and there is a Due Date field to let Dept. B know when their step needs done.&nbsp; Dept. A has a habit of just putting today's day as Due Date.&nbsp; Dept. A has been told multiple times not to do this but still does it anyway.&nbsp; Is there a way to restrict that field so that Due Date cannot equal Today?
(I don't need or want it to auto calculate based on a set time frame, like today is 3/15 so the due date is automatically 3/16.&nbsp; The due date could be 3/16 or it could be 3/21 or it could be 4/28, as long as it is a least 1 day in the future so that Dept. B actually has time to work on it.)------------------------------Brianne Jacobsen------------------------------

markshnier__you · Answer

Try this
Make a new&nbsp; formula numeric field called [Record ID# mirror] with a formula of
[Record ID#]
That will give us a hook we can use in a form rule to determine if the record has been saved yet.
Then make a formula like this.&nbsp;
When the record is saved
Conditions:
all of:
[Record ID# mirror] is (blank)
[Due date] is "the current date"

ACTION:
Abort the save with message.
Sorry, but you cannot inflict a date of Today as the Due Date for your co-workers.&nbsp; They need more time than that :)&nbsp;------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

briannejacobsen · Answer

That did it.&nbsp; Thank You!------------------------------Brianne Jacobsen------------------------------

Forum Discussion

Due Date cannot be today