Skip to main content
Nintex Community Menu Bar

O365: Form Variable that calculates a future date

  • December 6, 2021
  • 1 reply
  • 41 views
L
Forum|alt.badge.img+2

I am new to creating a variable to be used on the New Responsive Form that will calculate a future date when taking into consideration two columns with different field types. Column A is a date/time column and Column B is a number column. For my list I am using a calculated column with the following formula to display a date: =IF([Days Supply]>80,[Last Disp]+([Days Supply]-15),[Last Disp]+([Days Supply]*0.75))

 

I would like for this date to also appear on the form for end users to see when working on a profile, but every time I create the form variable it comes with an error. Any advise would be much appreciated.

20845iFB908AE635FC7BAA.png

 

    1 reply

    D
    Forum|alt.badge.img+6
    • David-
    • January 3, 2022

    You should be able to do this with a rule and use a date field where you want it to display on the form (you can then make the field read only if needed):

    For the then statement: dateAdd("days",sum([Form].[DaysSupply]-15),[Form].[LastDisp])

    For the Else statement: dateAdd("days",sum([Form].[DaysSupply]*.75),[Form].[LastDisp])

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