SharePoint validation between two date columns in the same list

Question

I have created a leave request list. I want to make sure that the End Date entered is greater than or equal to the Start Date. In the End Date column validation setting, I entered the formula:

=[End Date]>=[Start Date]

i get the error message: Check the formula for spelling mistakes or update the formula to reference only this column.

Is there an alternative to using validation to ensure an acceptable value in the End Date column of the same or a future date as Start Date?

Answer 1

Hi Shep,

Column validation is used to validate datatype. To achieve the validation between different columns, you need to use the following steps:

1. Go to List settings > General Settings > Validation settings.
2. Add your formula, save your changes and test.

All the explaination can be found in this similar thread: SharePoint 2013: The formula cannot refer to another column

Regards,

Sky

Answer 2

Sky,

Thank you very much! Worked like a charm.

Shep