9 Replies Latest reply: May 19, 2015 10:33 AM by swarup malli RSS

    If max(salesDate) is less than now() by 32 hours  then turn red else green

    Balraj Prabhu

      Hi,

       

      I have a field sales date, I want to turn it red if its older than 32 hours  from now i.e now() function which picks the date and time from the system.

       

      I tried some like this

      if ( max(sales date) < today() , red() )

       

       

      How do I add 8 hours to today() ?

      the format of sales date is as follows

      2015-05-17 23:59:02.000