Skip to main content
Nintex Community Menu Bar
Solved

Expression to determine the status according to the entered date, whether the date is old or new.

  • November 8, 2023
  • 1 reply
  • 23 views

Forum|alt.badge.img+1

Hello there!

 

I wrote this expression as shown in picture below to determine the status according to the entered date, but it’s always print false in the view.

 

 when the entered date before today I need to save “Late” word in status field, and if the entered date is after today, I need to save “Progress” text in status field.

 

could you please help me to configure the problem here.

 

Many Thanks.

 

Best answer by Deon

Hello @Demah ,

 

I think I know what the problem is. The if statement expects a return value in the 2nd and 3rd argument, but you have a boolean statement in there. “=” is a comparison operator not an assignment operator.

 

To solve this take out the equation and simply put in the text Late and Progress in the 2nd and 3rd argument of the if statement and then have a data label on your form where you set the Expression property to this expression with the if statement.

 

 

View original
Translate
Did this topic help you find an answer to your question?

Deon
Forum|alt.badge.img+10
  • Rookie
  • November 9, 2023

Hello @Demah ,

 

I think I know what the problem is. The if statement expects a return value in the 2nd and 3rd argument, but you have a boolean statement in there. “=” is a comparison operator not an assignment operator.

 

To solve this take out the equation and simply put in the text Late and Progress in the 2nd and 3rd argument of the if statement and then have a data label on your form where you set the Expression property to this expression with the if statement.

 

 

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings