Skip to main content

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?

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.

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings