1 Reply Latest reply on Oct 10, 2012 1:32 PM by philmodjunk

    Adding 30 days to existing date field value

    rwuest1

      Title

      Adding 30 days to existing date field value

      Post

           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!

        • 1. Re: Adding 30 days to existing date field value
          philmodjunk

               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.