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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
NetSuite Admin Tip: Dynamic Date/Time Comparisons in Workflow Conditions using Custom Formula
The Condition Visual Builder in workflows only allows comparisons to a Static Date or Date/Time value as shown in the screenshot below.
There are use cases that would require comparison to a Dynamic Date or Date/Time value such as the Date Today, the Day a Month Ago, Last Week at 5:00 PM, and so on. In these scenarios, Custom Formula should be used.
Writing SuiteFlow Condition Custom Formulas would differ in whether a Server or Client Trigger is used and whether Date or Date/Time fields are involved. Approaches for each of these setups are detailed in the sections below.
----------------------------------------------------------------
3