Forum Discussion

KatieBardwell's avatar
KatieBardwell
Qrew Member
6 years ago

how do i prevent typographical errors to the date field?

I want to create a rule that kicks back in error when a date is before 1997 and after 2027 but I don't need the error to fire if the date field is blank.  I've tried this with the new table base rules...
Forms
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
I suggest that you build your actual formula in a normal formula field box so you can debug it there and see the results.

You formula is incorrect, but because its a screen shot I can't help you edit it, I would need to see the actual code.