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!
trying to Build a 'date of last activity' custom field
on the 'Edit Custom Entity Field' screen Under 'Validation & Defaulting' I have the formula tic box tic'd -and the following formula:
max({activity.date})keep(dense_rank last order by {activity.date})
but for some reason -the OLDEST activity dates are being listed -
example: "2010-09-20 00:00:00.0 America/Los_Angeles" when there are numerous other more recent activities.
What I really want is:
"2011-07-25" -just the date of the most recent activity...
Can anyone steel me in the right direction, please?