Skip to Content
0

Highlighting Expert Formulas

Nov 01, 2017 at 04:05 PM

22

avatar image
Former Member

I have a date field where I need to highlight any date greater than 1 year from today's date. Is this possible?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Brian Dong Nov 01, 2017 at 11:06 PM
0

Hi Tyson,

If the field is on the report, you can right-click on it and go to Format Field. In the Font tab, you have a set of properties you can set using formulas.

Beside the Color, click the formula button and try a formula like:

If {table.FIELD} >= Date (Year (Today + 1), Month (Today), Day (Today)) Then 
    crRed 
Else crBlack; 

So this checks the field against 1 year from Today's date and the font will be red or black.

You can do something similar with the other properties as well.

Good luck,

Brian

Share
10 |10000 characters needed characters left characters exceeded
Tammy Powlas
Nov 01, 2017 at 04:09 PM
0
Share
10 |10000 characters needed characters left characters exceeded