# No Data when using where time range with specific date time or less than

**URL:** <https://community.influxdata.com/t/no-data-when-using-where-time-range-with-specific-date-time-or-less-than/16129>\
**Category:** Store\
**Tags:** influxdb, time-series, time, influxql\
**Created:** [September 29, 2020, 12:09am UTC](https://community.influxdata.com/t/no-data-when-using-where-time-range-with-specific-date-time-or-less-than/16129 "2020-09-29T00:09:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![agomez](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/agomez/32/5676_2.png) [@agomez](https://community.influxdata.com/u/agomez)\
**Post date:** [September 29, 2020, 12:09am UTC](https://community.influxdata.com/t/no-data-when-using-where-time-range-with-specific-date-time-or-less-than/16129/1 "2020-09-29T00:09:37Z")

</div>

Hi,

I’m having a problem I’ve never had before:  
If I query  
select \* from measurement or  
select \* from measurement where time \> now() - 2d or  
select \* from measurement where time \>= ‘2020-09-27T00:00:00Z’\*  
I get the correct records

For example:

 ![Screen Shot 2020-09-28 at 7.54.39 PM](https://us1.discourse-cdn.com/flex023/uploads/influxdata/original/2X/d/d2a14c8d1e34eba51a2d123cf775be8ae63b220d.png)

But, if I use the following queries I get no results (and I should):  
select \* from measurement where time \<= ‘2020-09-27T03:00:00Z’ or  
select \* from measurement where time \>= ‘2020-09-27T00:00:00Z’ and time \<= ‘2020-09-27T20:00:00Z’

For instance if I use grafana and I use the now() - 24h I get the data, but if I zoom in or I specify time range from the past I get not data. I only get data back if the last point in the series is included in the query.

Can someone please help me!

- The data with the issues has datapoints every 30-60 minutes
- Influx 1.0.2
- In the same database I have other measurements that don’t behave like this

Thank you!

---

<div class="post-metadata">

**Author:** ![Anaisdg](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/anaisdg/32/6401_2.png) [@Anaisdg](https://community.influxdata.com/u/Anaisdg)\
**Post date:** [September 29, 2020, 6:57pm UTC](https://community.influxdata.com/t/no-data-when-using-where-time-range-with-specific-date-time-or-less-than/16129/2 "2020-09-29T18:57:02Z")

</div>

Hello @agomez,

I’m not sure what the problem is. Can you please try upgrading your InfluxDB version? 1.0 is quite old. Then can you let me know if this problem still persists?

Thank you 🙂

---

<div class="post-metadata">

**Author:** ![agomez](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/agomez/32/5676_2.png) [@agomez](https://community.influxdata.com/u/agomez)\
**Post date:** [October 2, 2020, 12:49am UTC](https://community.influxdata.com/t/no-data-when-using-where-time-range-with-specific-date-time-or-less-than/16129/3 "2020-10-02T00:49:33Z")

</div>

Thank you very much!

We’re doing the update; however, this wasn’t the issue.

I’m using python sdk to write data. It seems like the data contains some null values that were being passed as ‘’. I changed that to pass these values as None and now everything works well with this measurement.

Thank you for your help!