# Difference() by day will not show today created datapoints

**URL:** <https://community.influxdata.com/t/difference-by-day-will-not-show-today-created-datapoints/22629>\
**Category:** Fluxlang\
**Created:** [November 23, 2021, 10:58am UTC](https://community.influxdata.com/t/difference-by-day-will-not-show-today-created-datapoints/22629 "2021-11-23T10:58:50Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [December 13, 2021, 9:06pm UTC](https://community.influxdata.com/t/difference-by-day-will-not-show-today-created-datapoints/22629/2 "2021-12-13T21:06:16Z")

</div>

Hello @gjemp,  
Have you tried using the today() funciton?

> **[today() function | Flux Documentation](https://docs.influxdata.com/flux/v0/stdlib/universe/today/)**
>
> today() returns the now() timestamp truncated to the day unit.

You might need to use the timeShift() function

> **[timeShift() function | Flux Documentation](https://docs.influxdata.com/flux/v0/stdlib/universe/timeshift/)**
>
> timeShift() adds a fixed duration to time columns.

This thread might also be useful to you:

> [@Month aggregateWindow doesn't work with negative offset](https://community.influxdata.com/t/month-aggregatewindow-doesnt-work-with-negative-offset/21459):
>
> Hi, we have an issue that aggregateWindow for month doesn’t work correctly with negative offset. For zero offset it works fine, and for the following query ` from(bucket: “my\_bucket”) |\> range(start: 2021-01-24T14:10:31+02:00, stop: 2021-12-24T14:10:31+02:00) |\> filter(fn: (r) =\> r.\_measurement == “my\_measurement”) |\> filter(fn: (r) =\> r.machine == “123”) |\> filter(fn: (r) =\> r.\_field == “span”) |\> filter(fn: (r) =\> r.state == “working”) |\> aggregateWindow(every: 1mo, offset: 0s, fn: sum, c…

---

_[View the full topic](https://community.influxdata.com/t/difference-by-day-will-not-show-today-created-datapoints/22629)._