Adding 30 days to existing date field value
Given two fields named ["Enroll_D" (containing enrollment date)], and ["End_Date" (currently no value)].
I need help with my current script to populate the "End_Date" field value with the "Enroll_D" date value + 30 days.
Can someone offer the correct command to solve my dilemma? Thanks in advance!
No script needed. Use this calculation with your End_Date field--either as an auto-enter calcuation or make it a calculation field that returns "Date":
Enroll_D + 30
Dates are really number fields that record the number of days elapsed since 12/31/0000 so if you add or subtract an integer value from them you modify the date by that number of days.