Highlighting within a cell showing date formula as text not date

Using the following formula to highlight a cell (screenshot below). Trying to work out a way to convert this formula so that is shows the correct date not the weird text result.

Formula (text) = Case WHEN trunc({custbody_rci_lm_7daysbeforedue}) – trunc({today}) <= ‘3’ THEN ‘<p style=”font-style:italic;background-color:#4BB543;text-align: center;” > {custbody_rci_lm_7daysbeforedue}’ ELSE ” END


Highlighting within a cell showing date formula as text not date

Rookie Asked on November 23, 2022 in Saved Searches.
Add Comment
1 Answer(s)


I have no idea what that strange format is but there’s a few issues that I’d address in that formula first:

Formula (Text)

CASE WHEN trunc({custbody_rci_lm_7daysbeforedue}) – trunc({today}) <= 3 THEN '<span style="font-style:italic; background-color:#4BB543; text-align: center;">'||{custbody_rci_lm_7daysbeforedue}||'</span>' ELSE '' END



Intermediate Answered on November 24, 2022.

Hey Chris,

Thanks for the attempt to fix the issue. Unfortunately your formula resulted in a ‘ERROR: Invalid Expression’ error when running the saved search.



on November 25, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor