formula assistance - rich text w/date

Question

[SAND DATE STATUS]IF THE DATE IN [SAND DATE] FIELD IS "before today", display red status button, otherwise display blue button.IF(ToText([SAND DATE])&lt;(today)),"&lt;img src=\"https://images.quickbase.com/si/24/204-warning.png\" title=\"delete\"&gt;","&lt;img src=\"https://images.quickbase.com/si/16/224-point_blue.png\" title=\"TO DO\"&gt;")------------------------------BuildPro------------------------------

buildpro · Answer

CORRECTION...DISPLAY "WARNING BUTTON"...NOT RED BUTTON------------------------------BuildPro------------------------------

claudevon_roesg · Answer

TryIF([SAND DATE]&lt;today()),"&lt;img src=\"images.quickbase.com/si/24/204-warning.png\"&nbsp;title=\"delete\"&gt;","&lt;img src=\"images.quickbase.com/si/16/224-point_blue.png\"&nbsp;title=\"TO DO\"&gt;")------------------------------Claude von Roesgen------------------------------

claudevon_roesg · Answer

CorrectionIF([SAND DATE]&lt;today(),"&lt;img src=\"images.quickbase.com/si/24/204-warning.png\"&nbsp;title=\"delete\"&gt;","&lt;img src=\"images.quickbase.com/si/16/224-point_blue.png\"&nbsp;title=\"TO DO\"&gt;")------------------------------Claude von Roesgen------------------------------

Forum Discussion

formula assistance - rich text w/date