0

I have an unbound textbox on my form I put on the control source =Date()-[boundfield] and it works fine it gives the number of days I needed but I wanted to have an If statement in this unbound field so using the expression builder I typed on the Control Source.

 =iff(Date()-[boundfield] > 120, "Max","not max")

But the unbound field always display #Name?. What might be the error on my code?.

Juan Filipe
  • 403
  • 6
  • 11
  • 23

1 Answers1

1

=IIf((Date()-[Adate])>120,"P","N")

This should work, put brackets as like this

Dinesh Niduvani Somanna
  • 139
  • 4