Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
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.
0