Timezone issues with filters


Because our business involves multiple time zones, the local database is in UTC-0 time zone, but some reports are in UTC-8 time zone. In the case of excluding the use of SQL, is it possible to use a filter to obtain today's data in the UTC-8 time zone

Hi @colin123
Post "Diagnostic Info" from Admin > Troubleshooting.
And the exact database column type of pay_time.

There's work being done to add date manipulation options to expressions:
https://github.com/metabase/metabase/issues/19274 - upvote by clicking :+1: on the first post

  1. Do you mean that secondary development is required to support these functions? For example, date_add or the date function
  2. Our current database is MySQL

@colin123 Custom Expressions are Metabase functions, so there's no date_add() etc database functions. You will have to use SQL or create a View on your database until then.

Thanks!