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.