Team Members keeps using wrong date year

[Dan_Oliphant]

I use appsheet to input new jobs, and every now and again a salesperson will input a date that is in the past. For example, adding a job to the date 9/29/2017 instead of 9/29/2019. There must be a way to restrict or show a warning if the date is less than TODAY()

[RoSCA_La_Famili]

Yes there is a way to restrict or show a warning. All you need to do is adding a data validation formula (like [_THIS]>=TODAY() ) then customize an invalid value error message that will appear when ever the date entered by the salesperson is not correct.

[Lynn]

Hi @Dan_Oliphant You could also set Initial value to TODAY()