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.
What data type is "Time of Day"?
I am attempting to use 2 Time of Day fields on a custom record to record start and end, from which I hope to be able to calculate duration. (we also record date and I guess I need to join the date to the times to be able to perform the calculation?).
So I am using TO CHAR to try and see what these fields record and strangely in "list view" I see different results to what shows on the record.
In the list I see dates (always the start of a month) but then on the record I see a time
0