Preventing date selection for dates before the current date

Question

Hi,I have a date field that our users are selecting dates that are in the past and it should always be in the future/today. I didn't see any settings to prevent this from happening. Is there a formula or a setting to prevent a past date for just one field?Thanks!------------------------------Catelyn Atkinson------------------------------

markshnier__you · Answer

Well, here is what you asked for, but it may not be when you need.

You can use a form rule

When the Record is saved
Condition
[date] is before "the current date"

Action
Abort the save with a message "Sorry, but dates must not be in the past"

But the issue to consider is that though the passage of time, all dates will eventually be in the past, so no one will be able to edit the record. So,there will need to be more to this setup depending what your use case is.

Is this just for when the record is initially created?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

donlarson · Answer

Catelyn,Go to the Advanced settings for the Table and build a custom data rule.&nbsp; &nbsp;If use Date Created in the formula that will be the same as Today when the record is created.&nbsp; &nbsp;
------------------------------Don LarsonPaasporterWestlake OH------------------------------

sanjaygupta · Answer

Hi,I have similar requirement but my data record need to be updated on next date. then in that case it is asking to update all the date fields with current date.&nbsp;do we have an option to disable back date entry while selecting the date.RegardsSanjay------------------------------Sanjay Gupta------------------------------

Forum Discussion

Preventing date selection for dates before the current date

Related Content

Preventing Budget Overrun

Preventing Scheduling Conflicts

Prevent save a record - New forms

If Then Else formula with a multi select field.

Checkbox Fields Vs Multi-Select Fields for Tracking