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.

 

TIA,

John

1 Reply

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

Is the name of the column correct? 

michalkornet_0-1721237901406.png