I want a report’s text box conditinally formatted so if the date is betwen now and the next three months that area will be shaded green. I got the following expression to work on a query grid. But, in the expression is box for the conditional formatting I get an invalid syntax error.
Here is my expression:
Between Now() AND DateSerial(Year(Now()),Month(Now())+3,Day(Now()))
Any help would be appreciated.
Fay