How do compare date field values in a saved search formula

AI generated answer (using internal Slack threads):

To compare date field values in a saved search formula in NetSuite, you can use the

CASE WHEN

statement. For example, if you want to get the latest date between two date fields, you can use the following formula:

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

This formula will return the latest date between

date1

and

date2

. If you want to check whether two dates are equal, you can use the following formula:

CASE WHEN {date1} = {date2} THEN 'Yes' ELSE 'No' END

This formula will return 'Yes' if

date1

and

date2

are equal, and 'No' if they are not. However, if one of the fields has both date and time, a direct comparison will not work. In this case, you can subtract the two dates and check if the result is between -1 and 1. This is because the subtraction of two Date/Time fields will give a decimal result due to the time difference. Here is an example of how you can do this: 1. Create a formula numeric field in your results with the formula

{date1} - {date2}

. This will show you the result of the subtraction. 2. Then, in your criteria tab, you can validate if the result is between -1 and 1. Remember, these formulas should be used in a Formula Text field in your saved search. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******