5 Replies Latest reply: Feb 19, 2015 4:32 PM by Alec Smith RSS

    Timestamp Comparison to Standard Timestamp

    Alec Smith

      Hello,

       

      I need to add a background color based on whether a timestamp is before or after 12:00PM.  If the timestamp is before 12:00PM, the background color will be Red().  If the timestamp is after 12:00PM the color will be Green().  The issue is how do I evaluate the timestamp to compare to my standard of 12:00PM?  Below is what I came up with, but it's not working.  I know the issue is in the "Timestamp('12:00','hh:mm')," portion of the expression.  Thank you in advance for any assistance on this issue. 

       

      If(Timestamp(Date ,'hh:mm')<=Timestamp('12:00','hh:mm'),Red(), Green())