I suggest that you enable data validation on the Advanced Properties of the table.
Then we make a formula that calculates to an error message. If the error message is null, then the record will save. Else it will display the error message. This also works in Grid Edit or importing or any APIs whcih create records, so it is rock sold.
The formula would be
IF(Year(Today()) <> Year(Lease Processed],"Sorry, but the Lease Processed Year is not in the Current Year.")
Now, you may want to think about what will happen right near year end, say January 2nd where staff are still entering last year's records. Decide if you need to allow some wiggle room with an override checkbox.
IF(Year(Today()) <> Year(Lease Processed] and [Allow non-current Year]=false,
"Sorry, but the Lease Processed Year is not in the Current Year.")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------