I have a record. I want to create a list whereby it will list rows where today date is between 2 fields in the record. can it be done by saved search?

AI generated answer (using internal Slack threads):

Yes, you can create a list where today's date is between two fields in the record using a saved search in NetSuite. You can use a Formula (Date) criteria filter in your saved search. Here's a general idea of how you can set it up: 1. In your saved search criteria, add a new line with the type "Formula (Date)". 2. In the formula field, you can use a SQL expression to compare today's date with your two date fields. The formula could look something like this:

CASE WHEN {date1} <= {today} AND {date2} >= {today} THEN 1 ELSE 0 END

3. Set the operator to "equal to" and the value to 1. This will return all records where today's date is between the two date fields in the record. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******