Forum Discussion

johncrouse62's avatar
johncrouse62
Copper Contributor
Jul 11, 2024

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...
Lists
microsoft lists
SharePoint Online
michalkornet's avatar
michalkornet
Steel Contributor
Jul 17, 2024

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

Is the name of the column correct? 

 

  • johncrouse62's avatar
    johncrouse62
    Copper Contributor
    Aug 06, 2024
    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.