Search This Blog

Friday, March 20, 2015

Date Validation in SharePoint

Introduction

In this post we will see how to implement SharePoint validations taking example of a scenario. I have observed many users got struck implementing some basic validations. Hope my series of SharePoint validation articles helps everyone to resolve their issues right from basics to advanced.

Scenario – StartDate Should be greater than DueDate
I am using following List Columns and their type in the example
StartDate – Date and Time
DueDate – Date and Time

Formula

=DueDate>StartDate


Formula and validation message setting

Formula will be inserted from list settings > validation SETTINGS OPTION. This is list level validation as formula involves with two different columns

Validation Message


No comments:

Post a Comment