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!
Using Current Date in Formula Field
Hi,
I am needing to add a formula field to a custom record that is True or False based on a date value. I'm not sure what the syntax, or if its possible, to determine the current date.
Basically I want something like this:
if (end_date < getDate()) {expired = 'T';} else {expired = 'F';}
I'm not sure of the proper syntax for 'getDate()'.
The expired field would not be stored, just used for display in search results or conditional formatting.
Can this be done? I don't see any functions for the current date.
Any help would be appreciated.
Thanks,