3 Replies Latest reply on Feb 27, 2012 6:00 AM by Bea_1

    Date Days Due Date

    Bea_1

      Title

      Date Days Due Date

      Post

      Another problem...

      I have a field that let's you enter a date.

      Then a field for terms.

      What i want in the Due Date field is that from the date i entered it'd add the terms so that it'd create a due date.

      Ex :

      Date : 27/02/2012

      Terms: 10 (days)

      Due Date : 08/03/2012 (this should be on this field)

      What would be the equation?

      Thanks in advance!

        • 1. Re: Date Days Due Date
          Sprucegum

          Hi Bea,

          If <Date> is defined as a date field, and <Terms> is defined as a number field and ALWAYS refers to a number of DAYS, you can use the following calculation for the Due Date field:

                Date + Terms

          If <Terms> is defined as a text field (including the text "(days)"), you'll need to consider all the different ways data is entered in this field to determine how best to use the GetAsNumber function to extract the number of days to add.  For example:

                Date + GetAsNumber(LeftWords(Terms; 1))

          • 2. Re: Date Days Due Date
            Bea_1

            i tried that Date+Terms = Due Date

            it does not work... =(

            • 3. Re: Date Days Due Date
              Bea_1

              YEY!!! it worked! i just forgot to change the calculation result type...

              Thanks Sprucegum! Kiss