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!
Saved Search for Cases - Format Date
I am using the Incident Date from the Case form in a Saved Search, but this is a date time field.
I want to group the search by date, so I need to convert date/time to date.
The only way I have been successful so far is using TO_CHAR({time},'DD/MM/YYYY') but this gives a Text field (which doesn't sort properly).
I tried TO_DATE(TO_CHAR({time},'DD/MM/YYYY'),'DD/MM/YYYY') but that seemed to put it back to date/time for some reason
I tried variations with ROUND({time},'DD/MM/YYYY') and TRUNC