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!
Date Formula Calculation
Hi folks,
I'd really appreciate a little help with this.
I'm trying to calculate the number of months between two "dates" and not having much luck. I've been working on it for a couple of days now and I keep getting an unexpected error which tells me that NS does not like the formula.
I need to look at a future revenue figure for say 3 months from today's date and using the following formula:
Formula (Numeric)
MONTHS_BETWEEN({customer.custentity_en_expirydate},ADD_MONTHS({today},3)
I'm just learning about the functions and formulas in NS and I'm sure it will be very beneficial when I do get my head around it but for now I need this saved search as of yesterday.