Friday 9 December 2011

Add Expiry Date to a List

Problem:  I have a list and each time the list item is approved, I need to add 180 days to the expiry date.

Initial Hypothesis: Create a Date and Time site column in the list.  Edit the "Calculated Value" box with a formula that will add 180 days to the current date.

Resolution: The formula to move the expiry date 180 days from the current date is:
=DATE(YEAR(Today),MONTH(Today),DAY(Today)+180)

0 comments:

Post a Comment