GitHub user dosubot[bot] added a comment to the discussion: Time Range Filters Are 1 Hour Behind CST (Asia/Shanghai)
<!-- Answer --> This is a known limitation in Superset: time range filters like “Last Week” are always calculated in UTC, not in your server’s local timezone. That’s why you see a 1-hour offset in Asia/Shanghai (UTC+8)—the filters update based on UTC midnight, not local midnight, so the range appears “late” by your local time. There’s currently no built-in way to make these filters follow the server’s timezone or a user’s local timezone in version 4.0.1. The only reliable workaround is to use manual date selection in the filter, rather than relative options like “Last Week” or “Today” [source](https://github.com/apache/superset/issues/35422). The “Hours Offset” feature in the Edit Dataset modal can shift timestamps, but it doesn’t fix this for all use cases and doesn’t affect the filter logic itself. There’s an active proposal (SIP-186) and ongoing work to add a user timezone selector, which would allow time range filters to honor the user’s selected timezone and display correct date ranges [source](https://github.com/apache/superset/issues/35422). For now, this is a known limitation and area of active development. <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/2182c402-78d8-4b41-8e6a-0b2e4cc772f1?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/2182c402-78d8-4b41-8e6a-0b2e4cc772f1?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/2182c402-78d8-4b41-8e6a-0b2e4cc772f1?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/2182c402-78d8-4b41-8e6a-0b2e4cc772f1?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/2182c402-78d8-4b41-8e6a-0b2e4cc772f1?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/2182c402-78d8-4b41-8e6a-0b2e4cc772f1?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/2182c402-78d8-4b41-8e6a-0b2e4cc772f1?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github) [](https://cursor.com/link/prompt?text=This%20is%20a%20known%20limitation%20in%20Superset%3A%20time%20range%20filters%20like%20%E2%80%9CLast%20Week%E2%80%9D%20are%20always%20calculated%20in%20UTC%2C%20not%20in%20your%20server%E2%80%99s%20local%20timezone.%20That%E2%80%99s%20why%20you%20see%20a%201-hour%20offset%20in%20Asia/Shanghai%20%28UTC%2B8%29%E2%80%94the%20filters%20update%20based%20on%20UTC%20midnight%2C%20not%20local%20midnight%2C%20so%20the%20range%20appears%20%E2%80%9Clate%E2%80%9D%20by%20your%20local%20time.%20There%E2%80%99s%20currently%20no%20built-in%20way%20to%20make%20these%20filters%20follow%20the%20server%E2%80%99s%20timezone%20or%20a%20user%E2%80%99s%20local%20timezone%20in%20version%204.0.1.%20%0A%0AThe%20only%20reliable%20workaround%20is%20to%20use%20manual%20date%20sel ection%20in%20the%20filter%2C%20rather%20than%20relative%20options%20like%20%E2%80%9CLast%20Week%E2%80%9D%20or%20%E2%80%9CToday%E2%80%9D%20%5Bsource%5D%28https%3A//github.com/apache/superset/issues/35422%29.%20The%20%E2%80%9CHours%20Offset%E2%80%9D%20feature%20in%20the%20Edit%20Dataset%20modal%20can%20shift%20timestamps%2C%20but%20it%20doesn%E2%80%99t%20fix%20this%20for%20all%20use%20cases%20and%20doesn%E2%80%99t%20affect%20the%20filter%20logic%20itself.%0A%0AThere%E2%80%99s%20an%20active%20proposal%20%28SIP-186%29%20and%20ongoing%20work%20to%20add%20a%20user%20timezone%20selector%2C%20which%20would%20allow%20time%20range%20filters%20to%20honor%20the%20user%E2%80%99s%20selected%20timezone%20and%20display%20correct%20date%20ranges%20%5Bsource%5D%28https%3A//github.com/apache/superset/issues/35422%29.%20For%20now%2C%20this%20is%20a%20known%20limitation%20and%20area%20of%20active%20development.) [](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/discussions/36449) GitHub link: https://github.com/apache/superset/discussions/36449#discussioncomment-15190842 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
