[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
------------------------------
Question
formula assistance - rich text w/date
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.