# Flux range can't find datapoint with \_time value within the specified range

**URL:** <https://community.influxdata.com/t/flux-range-cant-find-datapoint-with-time-value-within-the-specified-range/31710>\
**Category:** Fluxlang\
**Tags:** flux\
**Created:** [October 4, 2023, 12:51pm UTC](https://community.influxdata.com/t/flux-range-cant-find-datapoint-with-time-value-within-the-specified-range/31710 "2023-10-04T12:51:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sezanzeb](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/sezanzeb/32/10121_2.png) [@sezanzeb](https://community.influxdata.com/u/sezanzeb)\
**Post date:** [October 4, 2023, 12:51pm UTC](https://community.influxdata.com/t/flux-range-cant-find-datapoint-with-time-value-within-the-specified-range/31710/1 "2023-10-04T12:51:33Z")

</div>

I have datapoints with various \_time values. One of them has a \_time value of `2023-04-15 11:07:12 GMT+2`

With a range of

```auto
range(
  start: 2023-04-15T10:00:00.000+02:00,
  stop: 2023-04-16T13:00:00.000+02:00
)

```

I can find it (notice that the stop timestamp is one day later). I can locate the datapoint, and in its `_start` value it says `2023-04-15 10:00:00 GMT+2`, and in its `_stop` value `2023-04-16 01:00:00 GMT+2`

A range of

```auto
range(
  start: 2023-04-15T10:00:00.000+02:00,
  stop: 2023-04-15T13:00:00.000+02:00
)

```

doesn’t. The `_stop` value of all datapoints is `2023-04-15 01:00:00 GMT+2`. It finds datapoints with `_time` values from `2023-04-15 10:07:14 GMT+2` to `2023-04-15 12:57:14 GMT+2`, but the datapoint I am looking for is not there.

Absolutely no clue what’s going on there. The query looks very basic to me. I just filter by \_measurement and tags, nothing else. There is no aggregation of some sorts going on in my query that might omit the datapoint.

1. Why is \_stop showing something completely different from my range query?
2. What could cause the datapoint to go missing

---

<div class="post-metadata">

**Author:** ![fercasjr](https://avatars.discourse-cdn.com/v4/letter/f/e495f1/32.png) [@fercasjr](https://community.influxdata.com/u/fercasjr)\
**Post date:** [October 4, 2023, 4:12pm UTC](https://community.influxdata.com/t/flux-range-cant-find-datapoint-with-time-value-within-the-specified-range/31710/2 "2023-10-04T16:12:12Z")

</div>

so, _start and_ stop values will be always the ones you set as \_start and \_stop.

the actual timestamp is the \_time value.

and \_stop value is evaluated as “less than” so if your \_time value is as an example: 2023-04-15T13:00:00.000+02:00, it won’t show up. with this range:

range(  
start: 2023-04-15T10:00:00.000+02:00,  
stop: 2023-04-15T13:00:00.000+02:00  
)

because is equal to the \_stop value, not less.

I am not sure if this was your issue, but hope It helps.

also, there is a bug on which the time is shown as 12hrs format, so :2023-04-15 01:00:00 GMT+2 is indeed 2023-04-15T13:00:00.000+02:00 (I’ve noticed that on the Influx Data Explorer Interface table view)

---

<div class="post-metadata">

**Author:** ![sezanzeb](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/sezanzeb/32/10121_2.png) [@sezanzeb](https://community.influxdata.com/u/sezanzeb)\
**Post date:** [October 5, 2023, 6:08am UTC](https://community.influxdata.com/t/flux-range-cant-find-datapoint-with-time-value-within-the-specified-range/31710/3 "2023-10-05T06:08:52Z")

</div>

> also, there is a bug on which the time is shown as 12hrs format

Thanks, I already noticed this on \_start and \_stop in the ui, but your remark made me realize this might be the case for the displayed \_time value as well. Turns out the timestamp of my datapoint is not `2023-04-15 11:07:12 GMT+2`, but `2023-04-15 23:07:12 GMT+2`…