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!
Formula (Date/Time) how to show only time
Hello, I have searched and tried several format or parse options but cannont seem to get the result below to show only the time portion.
I'm using the following in a saved search Results column:
Formula (Date/Time) nvl({custcolendtime},{custbodyetdtime})
Both fields (custcolendtime and custbodyetdtime) are Time of Day and have only time values but the result is a date with the time value:
Example: 2/1/2010 4:30
I only want the 4:30 to show. It is 24 hour time so I don't need AM/PM. If it helps to know, for each result the correct time shows and the date is always 2/1/2010. I don't want the date so that value does not matter.