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!
Workflow Show Message Action on {trandate} if greater then {today} + 90
I have been working on this condition for most of the day. I got it fire, but it was firing on all dates. These are the condition formula's I have tried:
TO_DATE(TO_CHAR({today}, 'YYYY') || '-12-31', 'YYYY-MM-DD')
{trandate} > TO_DATE(TO_CHAR({today}, 'YYYY') || '-12-31', 'YYYY-MM-DD')
{datefield} <= {today} + 90
{trandate} <= ADD_MONTHS({today}, 3)
{trandate} + 30
TO_DATE({trandate}) <= TO_DATE({today} + 90)
The workflow trigger is After Field Edit on the date field using a custom formula.
I have also tried to create using the visual formula but will not take any expression on the date, or states value needs to be M/DD/YYYY