formula assistance - rich text w/date
[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])<(today)),
"<img src=\"https://images.quickbase.com/si/24/204-warning.png\" title=\"delete\">",
"<img src=\"https://images.quickbase.com/si/16/224-point_blue.png\" title=\"TO DO\">")
------------------------------
BuildPro
------------------------------
IF THE DATE IN [SAND DATE] FIELD IS "before today", display red status button, otherwise display blue button.
IF(ToText([SAND DATE])<(today)),
"<img src=\"https://images.quickbase.com/si/24/204-warning.png\" title=\"delete\">",
"<img src=\"https://images.quickbase.com/si/16/224-point_blue.png\" title=\"TO DO\">")
------------------------------
BuildPro
------------------------------
