1 Reply Latest reply on Apr 5, 2009 3:00 PM by comment_1

    Dates - changing the formatting

    brucewashington

      Title

      Dates - changing the formatting

      Post

      This is first request on formatting dates.  The first is I need to put a date in a field which is a future and then I need to add 10 years to it less 1 day.  The problem is if I put in 1 July 2009 and then need to have it be be 30 June 2039 but right now I am using the following formula and getting 0 July 2009.

       

      Thanks for any help on this.

       

      Bruce

       

       

        • 1. Re: Dates - changing the formatting
          comment_1
            

          First, make sure you enter the date into a Date field. Then define a second field as a Calculation field (result type is Date) =

           

          Date ( Month ( EnteredDate ) ; Day ( EnteredDate ) ; Year ( EnteredDate ) + 10 ) - 1 

           

           

          You can format both fields to display any way you like, using Format > Date… while you are in Layout mode.