Skip to main content
Nintex Community Menu Bar

Attempting maturity date need help

  • September 17, 2020
  • 1 reply
  • 10 views
Forum|alt.badge.img

I have a "term" field which can hold numbers from representing months in a term (120, 240,360) field, next we have "first payment date" field, lastly we have a "maturity date" field. Is it possible to input a first payment date example "12/1/2019" then select term "360"  which would have the maturity date calculate and show as "11/1/2049" in date format? 

*Example 12/1/2019 x 360 months = 11/1/2049

 

Also note I do not have the ability to user "action" in settings (do not have that access to use this at the moment) is there another way to achieve my goal?

    1 reply

    Forum|alt.badge.img+2
    • rjimenez89
    • Novice
    • September 23, 2020

    Yup, this is super easy with a calculated field in the forms designer.  Your formula would be dateAddMonths(termStartDateControl,termMonthsControl), found in the runtime functions tab.  You can then tie this calculated control to a text field in your list.  If you need it stored as a date in SP, create a calculated column in your list and set the column type to Date/Time.

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement