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.
Update: Narrative Insights has been restored and is now available.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Compare two fields on email template
Hi,
I want to compare two fields on the email template and put it under the IF function.
I created a custom field type integer number called "custrecord_today_date" that calculates the difference between the warranty end date field and today's date. The formula for this custom field is:
"ROUND(({custrecord_warranty_end_date}-{today}),0)".
For example, when I put {custrecord_warranty_end_date}= 12/06/2023, I get on this field the result "-2".
Now I want to create if on the email template to check if the custom field I created is less than 0 or greater than 0.
I tried to use the below syntax on the email template, but I get the below error when trying to save-
0