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.
Hello
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.