When creating a calculated field, if you wish to have the ability to over-write it with a manual input, be sure to specify a user date field in field one or two and rename it as reserved. It will be needed to store the values of manual input over-rides over the top of the calculated date.
That being said there are 4 new operators in ManagePro that make it possible for you to add a tremendous range of solutions using date fields. Those operators are:
| 1. | Add Days - create a calculated field that is a specified number of days beyond a targeted date field (ex. 5 days after the start date) |
| 2. | Subtract Days - create a calculated field that is a specified number of days before a targeted date field (ex. 5 days before the due date) |
| 3. | From Today -very helpful in knowing the number of days from today’s date to a record’s start or due date |
| 4. | From Selected Goal - a date based calculated on the number of days to reach a specified goal’s due date – very helpful in determining number of days remaining |
Example:
FromToday” subtracts the selected date field from today and returns a duration value.
“FromSelectedGoal” subtracts the Field2 value of the selected goal from the Field1 value of each goal.. ie. in this example every goal would show the number of days between its due date and the due date of the goal “submit proposal”
