1 Reply Latest reply on Feb 26, 2009 12:16 AM by davidhead

    Date adding

    brucewashington

      Title

      Date adding

      Post

      I need to add two days to todays date.  One is 30 years less one day and the second is 10 years less one day.

      Is there a simple way to do this off a date field?

      Thanks for help.

      Bruce

        • 1. Re: Date adding
          davidhead
            

          "30 years less one day" would be:

           

          Date ( Month ( Get ( CurrentDate ) ); Day ( Get ( CurrentDate ) ); Year ( Get ( CurrentDate ) ) + 30 ) - 1 

           

          And "10 years less one day" would be:

           

          Date ( Month ( Get ( CurrentDate ) ); Day ( Get ( CurrentDate ) ); Year ( Get ( CurrentDate ) ) + 10 ) - 1  

           

          Both would be unstored calculations.