# Query is not respecting date range

**URL:** https://community.bitquery.io/t/query-is-not-respecting-date-range/1873
**Category:** GraphQL API
**Created:** [April 14, 2024, 2:29pm UTC](https://community.bitquery.io/t/query-is-not-respecting-date-range/1873 "2024-04-14T14:29:51Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![zoveress](https://avatars.discourse-cdn.com/v4/letter/z/7c8e57/32.png) [@zoveress](https://community.bitquery.io/u/zoveress)
#### Post date: [April 14, 2024, 2:29pm UTC](https://community.bitquery.io/t/query-is-not-respecting-date-range/1873/1 "2024-04-14T14:29:51Z")

</div>

The following query will start listing data from 2024-04-06T00:00:00 instead of the defined 2024-04-06T17:00:00. Any idea why is this happening?

{  
ethereum(network: bsc) {  
dexTrades(  
baseCurrency: {is: “0x96ed4db01218608e6c8a8d66c65bdf59601ee735”}  
quoteCurrency: {is: “0xbb4CdB9CBd36B01bD1cBaEBF2De08d9173bc095c”}  
date: {since: “2024-04-06T17:00:00”, till: “2024-04-11T13:50:00”}  
options: {limit: 25000, asc: “block.timestamp.unixtime”}  
) {  
quotePrice  
transaction {  
hash  
}  
block {  
timestamp {  
unixtime  
}  
}  
}  
}  
}

---

<div class="post-metadata">

### Author: ![akshat.bitquery](https://avatars.discourse-cdn.com/v4/letter/a/dbc845/32.png) [@akshat.bitquery](https://community.bitquery.io/u/akshat.bitquery)
#### Post date: [April 17, 2024, 9:49am UTC](https://community.bitquery.io/t/query-is-not-respecting-date-range/1873/2 "2024-04-17T09:49:49Z")

</div>

: Its because you are using date to filter `date: {since: “2024-04-06T17:00:00”, till: “2024-04-11T13:50:00”}` use `time: {since: “2024-04-06T17:00:00”, till: “2024-04-11T13:50:00”}` instead then it will also take care of exact time you need to filter from.

---

<div class="post-metadata">

### Author: ![zoveress](https://avatars.discourse-cdn.com/v4/letter/z/7c8e57/32.png) [@zoveress](https://community.bitquery.io/u/zoveress)
#### Post date: [April 17, 2024, 10:03am UTC](https://community.bitquery.io/t/query-is-not-respecting-date-range/1873/3 "2024-04-17T10:03:28Z")

</div>

Works like charm, many thanks!
