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

    Format Portal Field based on calculation


      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?