AnsweredAssumed Answered

Format Portal Field based on calculation

Question asked by Ben_B94 on Apr 22, 2016
Latest reply on Apr 22, 2016 by 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?