You’re offline. This is a read only version of the page.
Announcements
25
Looking for some help adding 2 fields together into a third date field. Below are the 2 fields needed to calculate/update the third field.
'Actual Start Date' (date field):
PLUS
'Assignment Length' (decimal field which is entered in as months. So this would read as 5 months)
EQUALS
'Estimated End Date' (date field)
Not sure if this would end up just being a calculated field but wanted to know if it can be done.
Thanks in advance.
I believe this could be done using a calculated field
You could use something like ADDMONTHS (date field, length field) to add a whole month (e.g. 28th June + 5 months = 28th November)
If you wanted to count a month as 28 days, you could use a calculated field to multiply 5 x 28 then add that to your original date
Share
Report
All responses (
Answers (
