Various questions on Influx tasks

@nygma2004,
Thanks for clarifying. How are you creating these tasks? In the UI? Is your time set to local or UTC in the UI when you’re creating the task? Do you create the task from the data explorer and then select save as task?

  1. You could use cron scheduling instead which runs on the system time: InfluxDB task configuration options | InfluxDB Cloud Documentation
  2. Please check out these threads there are various solutions: Month aggregateWindow doesn't work with negative offset
    Query to generate windowed aggregates with timestamp at window start and without partial data
    Out of curiosity which video was that?