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!
I give up - How do we use a TimeOfDay field as search criteria?
In the past I've used terrible epoch millisecond timestamp hacks to filter search results based on a time field.
On my most recent mini-project I thought I would try a Date field paired with a Time field (still can't believe they are separate).
I'm really struggling on a criteria that will evaluate "{timeField} > now"
Date fields have the nice date presets, but TimeOfDay doesn't. Is the only solution to convert the TimeOfDay into some other type and do some sort of arithmetic in a formula?
The other problem I've found is that TimeOfDay fields hold the first day of the month they were set in. For example, if I were to store a value in a TimeOfDay field then use it in a formula I would get 2008/9/1 (or something like that). So the date is incorrect, not to mention the fact that it displays a date by default instead of the time.
Steve Klett | Senior Developer
NetValue Technology