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!
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
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