Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
NSC | How to get the same day as 3 months ago in a Transaction Saved Search?
In cases Users would like to get a different Date Range specifically the same day from months ago, we can use a Formula (Date) to achieve it.
You may add this Formula (Date) to your Criteria or Results tab:
TRUNC(ADD_MONTHS(TO_DATE({today}), -3), 'D')+TO_NUMBER(TO_CHAR({today}, 'D')-TO_CHAR(TRUNC(ADD_MONTHS(TO_DATE({today}), -3), 'D'), 'D'))
You can also set the number of your preferred months by changing the number in the Formula.
I hope this helps! 😊
Do you have any tips when creating a Saved Search? Share it with us!