Sunday, September 21, 2014

SharePoint 2013 - Check if given date greater or lesser than today's date using calculated field


Create a new custom list and add 3 columns as follows:
1) TodaysDate of type Datetime with date only option. Choose the "Today's Date" default value.
2) EndDate of type Datetime with date only option.
3) Status of type Calculated Field. Enter the following formula in the Formula Box: =TodaysDate>EndDate.  Also, Choose The data type returned from this formula is: Yes\No

Now, go to the list enter some data. Following is the example.


No comments:

Post a Comment

Note: Only a member of this blog may post a comment.