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

Add Comment
1 Answer(s)

Hi,

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

Thanks,

Chris

Intermediate Answered 2 days ago.

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.

Thanks,

AP

17 hours ago.
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   Limebox   Become a Sponsor   Become a Sponsor