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.