Skip to main content
Nintex Community Menu Bar

Validation that 2 calculated values are the same

  • March 26, 2019
  • 2 replies
  • 17 views

Forum|alt.badge.img+1

Good afternoon.

 

First time poster (I have searched for similar posts without luck) and self-taught in Nintex - wish me luck.

 

Scenario: I have 2 calculated values returning dates:

- one calculated value returns the first/earliest filled date (using the picker) out of 4 possible dates from left to right on my form (essentially returning the first date entered anywhere along a 4 step process) i.e. a start date

- the second calculated value returns the last/most recent filled date (using the picker) out of 4 possible dates from right to left on my form (essentially returning the most recent and most accurate date along a 4 step process) i.e. a completion date

 

Problem: I would like to build in validation that these two dates cannot be the same but am unable to get anything to work. I have the dates currently being returned as String, and have done an equals logic and a contains logic without luck. I have also tried returning the calculated values as an Integer, again, no luck.

 

Any help or direction where I can find a solution would be appreciated.

 

Thanks.

2 replies

Forum|alt.badge.img+14
  • Scholar
  • March 27, 2019

for calculated dates use validation formula like 

 

CalcStartDateNamedControl*1 == CalcEndDateNamedControl*1

Forum|alt.badge.img+1
  • Author
  • March 27, 2019

@emha - thanks for the help - fixed my issue. Much appreciated!