Forum Discussion
SharePoint / Teams Date Column Restriction using Validation Syntax Question
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?<TODAY() and does not work. Seems it is not recognizing the column name. Any thoughts
Any syntax examples would be greatly appreciated.
TIA,
John
Hi johncrouse62, I have checked your formula =[Last Updated Date]<=TODAY() and it works.
Is the name of the column correct?
- Yes, the column name is correct. I can set it in SP and it works for a bit, but the syntax shows up differently in Teams, as shown above, and eventually it no longer works.
