Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
3 years ago

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
------------------------------