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!
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.
----------------------------------------------------------------