Can you have a formula date field in saved search SQL and also use text after the ELSE statement?

AI generated answer (using internal Slack threads):

Yes, you can have a formula date field in saved search SQL and also use text after the ELSE statement. In NetSuite saved searches, you can use SQL expressions in the formula fields. For example, you can use a CASE statement to compare two date fields and return the latest date. Here is an example:

CASE WHEN {date1} > {date2} THEN {date1} ELSE {date2} END

In this example, if date1 is later than date2, then date1 is returned. Otherwise, date2 is returned. You can also use text after the ELSE statement in a CASE expression. For example, you can return a specific text value if a condition is not met. Here is an example:

CASE WHEN ({actualshipdate} > {shipdate}) THEN 2 ELSE 'Late Order' END

In this example, if the actual ship date is later than the expected ship date, then 2 is returned. Otherwise, the text 'Late Order' is returned. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******