3 Replies Latest reply on Apr 22, 2016 8:47 AM by Ben_B94

    Format Portal Field based on calculation

    Ben_B94

      How do you do this? Field in question is a date.

       

      I tried

      if ( dateReminder < Get ( CurrentDate) + 14 )

      Set Variable: $date ; Value; Get as text ( dateReminder)

      set field ( dateReminder ; TextColor ( $date; etc ; etc; etc ) )

       

      Basically trying to change the colour of the dateReminder 2 weeks before we hit the date of dateReminder to make you aware the date is approaching.  

       

      Also is that date calculation right?

       

      Thanks