# UTC offset when querying

**URL:** <https://forums.ordoro.com/t/utc-offset-when-querying/351>\
**Category:** Bug Reports\
**Created:** [January 3, 2019, 1:22am UTC](https://forums.ordoro.com/t/utc-offset-when-querying/351 "2019-01-03T01:22:45Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![sergio.nader](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@sergio.nader](https://forums.ordoro.com/u/sergio.nader)\
**Post date:** [January 3, 2019, 1:22am UTC](https://forums.ordoro.com/t/utc-offset-when-querying/351/1 "2019-01-03T01:22:45Z")

</div>

I need to get what was shipped in a given day. Let’s say, Dec, 27, 2018

Considering that my timezone is -5h, will the following URL bring what I need?

[https://acess:info@apiverson.ordoro.com/order?shipped\_after=2018-12-26T19:00:00.000000-05:00&shipped\_before=2018-12-27T18:59:00.000000-05:00&limit=100](https://acess:info@apiverson.ordoro.com/order?shipped_after=2018-12-26T19:00:00.000000-05:00&shipped_before=2018-12-27T18:59:00.000000-05:00&limit=100)

Thanks and happy new year!

Sergio Nader

---

<div class="post-metadata">

**Author:** ![sophie](https://yyz1.discourse-cdn.com/flex029/user_avatar/forums.ordoro.com/sophie/32/19_2.png) [@sophie](https://forums.ordoro.com/u/sophie)\
**Post date:** [January 3, 2019, 4:55pm UTC](https://forums.ordoro.com/t/utc-offset-when-querying/351/2 "2019-01-03T16:55:36Z")

</div>

Hi @sergio.nader,

Yes, this should work for you, and you can even leave the millisecond precision outta there. Have you tried it out? Is there a bug you’ve found with it?

Thanks, and happy 2019 to you as well!

---

<div class="post-metadata">

**Author:** ![RELSTON](https://avatars.discourse-cdn.com/v4/letter/r/b9bd4f/32.png) [@RELSTON](https://forums.ordoro.com/u/RELSTON)\
**Post date:** [January 6, 2019, 8:12pm UTC](https://forums.ordoro.com/t/utc-offset-when-querying/351/3 "2019-01-06T20:12:22Z")

</div>

Hi Sophie.  
What end point is this? Not std api end point I think.  
I would lobe to be able to use shipped\_ffter and shipped\_before perameter on api/shipment or api/order end point.  
I do not see those perameters in the documentation.  
You have told me that start\_date and end\_date on shipment endpoint refers to order create date not shipment date.  
Is this a new feature?

When I send this - I get created date witin time window but shipment is outside it.  
Return from: shipment/?start\_date=2019-01-01T19:00:00-05:00&end\_date=2019-01-03T18:59:59-05:00&limit=100&offset=0&status=shipped&sort=-ship\_date  
116  
Total Found: 116  
0 : 1-000078250-1  
Created: 2019-01-03T23:17:39.160578+00:00.  
Shipped: 2019-01-04T21:21:12+00:00

---

<div class="post-metadata">

**Author:** ![sergio.nader](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@sergio.nader](https://forums.ordoro.com/u/sergio.nader)\
**Post date:** [January 7, 2019, 10:13pm UTC](https://forums.ordoro.com/t/utc-offset-when-querying/351/4 "2019-01-07T22:13:32Z")

</div>

Hey, Sophie. Right now I am using the date/time as 2018-12-27T18:59:00.0. Later I will try leaving the ms out.  
Thanks

---

<div class="post-metadata">

**Author:** ![sergio.nader](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@sergio.nader](https://forums.ordoro.com/u/sergio.nader)\
**Post date:** [January 7, 2019, 10:15pm UTC](https://forums.ordoro.com/t/utc-offset-when-querying/351/5 "2019-01-07T22:15:27Z")

</div>

Hey, Relston.

Here is where I find those parameters:  
[https://devapiverson.docs.apiary.io/#reference/order/order/get](https://devapiverson.docs.apiary.io/#reference/order/order/get)
