SharePoint / Teams Date Column Restriction using Validation Syntax Question

Copper Contributor

I have two date columns in a Sharepoint List. I am trying to figure out the proper syntax for usie in the Validation box.


For the first, I want to restrict the date entered to only accept today's date or prior dates.


For the second, I would like to restrict the date entered to today's date and future dates.


I enter "=[Last Updated Date] <= Today()" without the quotes, save, go back in and look and it has been changed to =#NAME?&lt;TODAY() and does not work. Seems it is not recognizing the column name. Any thoughts


Any syntax examples would be greatly appreciated.




1 Reply

Hi @johncrouse62, I have checked your formula =[Last Updated Date]<=TODAY() and it works.

Is the name of the column correct?