Issue with date.weekDay not showing right value?

InfluxDB 2
1

Hello, have something odd here (InfluxDB v2.2.0) please see below Flux:

import "dict"
import "date" 

months = [1:"January",2:"February",3:"March",4:"April",5:"May",6:"June",7:"July",8:"August",9:"September",10:"October",11:"November",12: "December"]
days = [0:"Sunday",1:"Monday",2:"Tuesday",3:"Wednesday",4:"Thursday",5:"Friday",6:"Saturday"]
from(bucket: "SRC")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "Measure1" or r["_measurement"] == "Measure2")
  |> filter(fn: (r) => r["_field"] == "value")
  |> filter(fn: (r) => r["host"] == "influxdb")
  |> aggregateWindow(every: 1d, fn: sum, createEmpty: false)
  |> group()
  |> map(fn: (r) => ({ r with 
    namedDay:
      dict.get(dict: days, key:date.weekDay(t: r._time), default: ""),
    namedMonth:
      dict.get(dict: months, key:date.month(t: r._time), default: "")
  }))

The result is attached. For some reason the namedDay / date.weekDay function is not showing a difference between the 12th and 13th?

Appreciate any help offered!

WeekDayQuery
WeekDayQuery1554×499 27 KB

2

This was related to the Time Zone. For some reason 1 column was in local time, and the functions did UTC in some combination.

Making sure everything used the same time zone got this sorted out.