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!
Modifying time output on saved search
Hi all,
Looking for some second opinions here on a search that outputs time in the following format.
'0 0:1:8.0' or '0 0:10:55.0'
Using LTRIM, I've managed to improve this somewhat to '10:55.000000' (as per last example)
This still isn't perfect, ideally I'd just get the hours, minutes and seconds. So 5:50:35 (Five hours 50 minutes and 35 seconds)
Any pointers, please? My field is a formula field is (exit time - created) and that gives me the problematic format. I am only able to use TEXT or DATE/TIME formula fields (numeric causes unexpected error on the search)
Thank you.