Documentation

boundaries.month() function

boundaries.month() returns a record with start and stop boundary timestamps for the current month.

now() determines the current month.

Function type signature
(?month_offset: int) => {stop: time, start: time}
For more information, see Function type signatures.

Parameters

month_offset

Number of months to offset from the current month. Default is 0.

Use a negative offset to return boundaries from previous months. Use a positive offset to return boundaries for future months.

Examples

Return start and stop timestamps for the current month

import "date/boundaries"

option now = () => 2022-05-10T10:10:00Z

boundaries.month(

)// Returns {start:2022-05-01T00:00:00.000000000Z, stop:2022-06-01T00:00:00.000000000Z}

Query data from this month

import "date/boundaries"

thisMonth = boundaries.month()

from(bucket: "example-bucket")
    |> range(start: thisMonth.start, stop: thisMonth.stop)

Query data from last month

import "date/boundaries"

lastMonth = boundaries.month(month_offset: -1)

from(bucket: "example-bucket")
    |> range(start: lastMonth.start, stop: lastMonth.stop)

Was this page helpful?

Thank you for your feedback!


Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.