how can I set a saved search result to be a formul...
# ask-stanley-ai
l
how can I set a saved search result to be a formula on a date field, and to add 89 days to that date?
c
AI generated answer (using internal Slack threads):
To set a saved search result to be a formula on a date field and add 89 days to that date, you can use a formula (date) field in the results tab of your saved search. Here is a step-by-step guide: 1. Navigate to the saved search you want to modify. 2. Go to the Results tab. 3. Click on New Column to add a new result field. 4. In the pop-up window, select Formula (Date) from the drop-down list. 5. In the Formula field, enter the following formula:
{your_date_field} + 89
. Replace
your_date_field
with the actual field id of your date field. 6. Click Save. This will add a new column to your saved search results that shows the date from your specified field plus 89 days. Please note that the formula field in NetSuite saved search uses Oracle SQL syntax, and the field names should be enclosed in curly braces
{}
. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.842308104
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.841934323
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.839919746
Please provide your feedback on this answer.