Solved

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

  • 8 November 2023
  • 1 reply
  • 22 views

Userlevel 1
Badge +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.

 

icon

Best answer by Deon 9 November 2023, 01:57

View original

1 reply

Badge +8

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.

 

 

Reply