I am creating a form with two date fields, Start Date and Expiration Date. I need to make sure that the Expiration Date is within 365 days of the Effective Date. IE Start Date 1/1/2019 Expiration Date 12/31/2019 is VALID, but Start Date 1/1/2019 Expiration Date 2/28/2020 is invalid. I tried creating a validation range where minimum value was set to Effective Date, then tried using the following formula for Maximum Value:
=fn-LessThanOrEqual(fn-DateDiffDays(Start Date, Expiration Date), 365)
Unfortunately, this always came back as false, no matter what date was entered.
I also tried creating a validation rule using this formula:
lessThanOrEqual(dateDiffDays(Start Date,Expiration Date),365) |
This also seems to always fail, regardless of the Expiration Date entered.
I'm not sure how to proceed from here. I'm new to formulas and functions in Nintex and could use some guidance. Also, if anyone has a link to a good basic tutorial on creating this formulas, it would be helpful. Thank you!