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!
Return the AM or PM value of a Time Field in Saved Search
Hi everybody!
I've previously used (TO_CHAR({fieldID}, 'hh24:mi') within a Formula(Text) results column to return the time. Now I'm trying to simply return whether the time was in the morning or afternoon by displaying the AM or PM value.
Does anyone know offhand what format I can use to capture this? I'm thinking it is probably just a code I need to update within the single quotes ( ' ) of the formula I've used previously - (TO_CHAR({fieldID}, '??AM/PM??')
Thanks in advance for any insight you may be able to offer!
-Tim-