ANS-0327 · WEB SERVICES & INTEGRATIONS
How Do NetSuite Web Services Operators ‘After’ and ‘OnOrAfter’ Handle Timestamps?
Understand the nuanced differences between the 'After' and 'OnOrAfter' operators when querying NetSuite data via web services with timestamp criteria.
Short answer
When using NetSuite web services, the 'OnOrAfter' operator typically evaluates records based on the date component, potentially disregarding specific time details if not precisely formatted. In contrast, the 'After' operator is designed to consider hours, minutes, and seconds, offering more granular comparison, though its accuracy can be influenced by timestamp formatting and timezone settings.
Scenario
When integrating external systems with NetSuite via web services, users often need to retrieve records based on date and time criteria. A common challenge arises when selecting between the 'After' and 'OnOrAfter' operators, as their behavior regarding the inclusion of hours, minutes, and seconds in timestamp comparisons can lead to unexpected results if not fully understood.
Solution
When querying NetSuite data via web services using timestamp criteria, the behavior of the 'OnOrAfter' and 'After' operators differs in how they handle time components:
OnOrAfter:
The OnOrAfter operator, when used with a timestamp as a criteria, typically evaluates records based on the date component. While NetSuite's dateTime type supports time components, practical application of OnOrAfter may often default to day-level precision if time components are not explicitly or correctly provided in the input timestamp, or due to complexities in timezone handling.
After:
The After operator is designed to take hours, minutes, and seconds into consideration for timestamp comparisons. This generally allows for more accurate and granular filtering. However, its precise behavior can be influenced by the exact formatting of the input timestamp and NetSuite's timezone settings, which may introduce complexities in practical application.
Expert NetSuite Support
Need help with this NetSuite issue?
Web Services & Integrations consulting and configuration support