Skip to main content
Question

Rich text duration field


Forum|alt.badge.img+3
Hello,

I am attempting to create a rich text field that will change the color of the field if the field is a negative or positive number.  The field I am attempting to do this on is called [YTD Change-Incoming to Answer].  That field is a duration field that displays the number of seconds between last years incoming to answer and this years incoming to answer.  If the number is a positive number, I want the field background to be red, as it is a negative change.  This is the formula I have but it won't let me use < or > since the field is a duration field.  Any ideas?

If([YTD Change-Incoming to Answer] > "0" , "<div style=\"background-color:red;\"> Urgent</div>", [YTD Change-Incoming to Answer] )

------------------------------
Courtneah Thomas
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Try this 


If([YTD Change-Incoming to Answer] > Days(0) , "<div style=\"background-color:red;\"> Urgent</div>", [YTD Change-Incoming to Answer] )


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------