Skip to Content
avatar image
Former Member

Highlighting Expert Formulas

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 01, 2017 at 11:06 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 01, 2017 at 04:09 PM
    Add comment
    10|10000 characters needed characters exceeded