Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
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!
Tagged:
0