in a saved search, how can i compare two dates?

AI generated answer (using internal Slack threads):

In a saved search, you can compare two dates using a formula. Here's an example of how you can do this: 1. Create a new saved search or edit an existing one. 2. In the Criteria tab, add a new criteria. 3. Select "Formula (Numeric)" from the dropdown. 4. In the Formula field, enter the following formula:

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

5. This formula will compare the two date fields (date1 and date2) and return the latest date. If you want to calculate the difference between two date and time fields but only during working hours (80000 am to 30000pm), you might need to modify the formula to suit your specific business hours requirement. Unfortunately, there's no direct way to do this in NetSuite, but you can refer to these SuiteAnswers articles for more information: - [Calculating the Difference Between Two Time Fields](https://suiteanswers.custhelp.com/app/answers/detail/a_id/25112/loc/en_US) - [Calculating the Difference Between Two Date/Time Fields](https://suiteanswers.custhelp.com/app/answers/detail/a_id/35451/loc/en_US) ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******