Fomula in a Text Box
I have form for employees, on this form there is an is a field in which the date of the employees induction is stored.
I created a text box and added the formula below to highlight if the employee needed a review induction. ie if the employee had been there for more than 1 year, then a review needs to be done. I want this to display on the form because it will only be looked at if a casual employee is going permanent BUT if I put the "greater than" sign one way they all come up the same and if I reverse it they all come up the other remark. Waht have I done wrong....
=iif([Induction Date](now()-365),"A review induction must be completed","A review induction is not necessary")
All help much appreciated.
Thanks
|