You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Operator BETWEEN not working for datetime field TransactionDate on inventoryCompletedTransactions

Summary:

I am trying to query Inventory transactions using TransactionDate as a datetime range, in the inventoryCompletedTransactions endpoint of the REST api. However, I continue to receive a format error on my timestamp operator.

Content (please ensure you mask any confidential information):

{{Server}}/11.13.18.05/inventoryCompletedTransactions?q=Item={{itemId}};OrganizationId={{orgId}};TransactionTypeId={{transactionId}};SourceReference={{workOrder}};TransactionDate BETWEEN '2025-05-26T16:46:34.000+00:00 AND "2025-05-26T16:46:36-00:00"&orderBy=TransactionDate:desc


I get the following error:

An instance of type java.sql.Timestamp cannot be created from string BETWEEN 2025-05-26T16: 46: 34.000 00: 00. The string value must be in format YYYY-MM-DDTHH:MI:SS.sss+hh:mm.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!