Saved search highlight if transaction date is greater than 14 days

AI generated answer (using internal Slack threads):

In NetSuite, you can't directly highlight rows in a saved search based on a condition. However, you can create a workaround by adding a formula field to your search that will display a colored text or symbol based on your condition. For your specific case, where you want to highlight if the transaction date is greater than 14 days, you can add a Formula (Text) field to your search with a formula like this:

sql
CASE 
WHEN {transactiondate} > SYSDATE - 14 THEN '🔴' 
ELSE '' 
END

This will add a red circle emoji to the rows where the transaction date is greater than 14 days. You can replace the '🔴' with any text or symbol you prefer. Remember to set the Summary Type of this field to 'Group' so that it appears on each row of the search results. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******