SharePoint / Teams Date Column Restriction using Validation Syntax Question

Question

I have two date columns in a SharePoint List. I am trying to figure out the proper syntax for use 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.

Any syntax examples would be greatly appreciated.

Ganesh Sanap - MVP · Accepted Answer · 2024-07-11 17:21:07Z

0

For the first date column, you can use column validation like:

=[Date Column]<=Today()

For the second date column, you can use column validation like:

=[Date Column]>=Today()

Example:

Note:

Sometimes comma(,) does not work in formula (it is based on language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).
Use correct display name of your SharePoint columns in above formula.
Wrap column names inside [] if your column name has space in it. For example: [My Column Name].

answered Jul 11, 2024 at 17:21

47.3k22 gold badges32 silver badges64 bronze badges

1 Answer 1