3 Replies Latest reply on Dec 19, 2013 7:31 AM by Thuy Nguyen

    If date meets certain timeframe then show red/ alert

    Thuy Nguyen

      Hello,

       

      I have a table with a list of technologies and dates of when they expire. At the moment I have created a Calculated field to count the number of days from today until when the particular technology expires.

       

      What I want is to also say is if this expiry date is within 70 days of today, then show red.

       

      In essence, I have a table which has a list of different technologies and dates of when it moves into "Expired" status. Is it possible to somehow show when a technology is close to its expired date to highlight in red or create an alert

       

      Thanks