Issues with returning accurate results when filtering by date(timezone issue maybe)


I have the following filters:

And this returns the following result:

However, there's one more item that wasn't returned which also has the same start and end date. Only difference is that rather than spanning the entire day, it starts by 2pm and ends at 4pm.
When I move the end date to 26th March, 2024. It then gets returned


This is the filter query:

WHERE "starts_at" <= COALESCE([[{{end_date}}::timestamp,]] CURRENT_DATE) AT TIME ZONE 'UTC'
AND "ends_at" >= COALESCE([[{{starts_date}}::timestamp,]] CURRENT_DATE) AT TIME ZONE 'UTC'

Does anyone have any idea what the possible issue could be? I'd appreciate any help. Thank you.

DIagnostic info:

  "browser-info": {
    "language": "en-GB",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KML, like Gecko) Chrome/ Safari/537.36",
    "vendor": "Google Inc."
  "system-info": {
    "file.encoding": "UTF-8",
    "": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.22+7",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "",
    "java.version": "11.0.22",
    "": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.22+7",
    "": "Linux",
    "os.version": "5.10.209-198.812.amzn2.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  "metabase-info": {
    "databases": [
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "14.10"
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.6.0"
    "run-mode": "prod",
    "version": {
      "date": "2024-02-22",
      "tag": "v1.48.7",
      "hash": "c192db1"
    "settings": {
      "report-timezone": "UTC"

Hi, if you're a paid customer remember that you have premium support, please write to our support email

Hi there. I'm not a paid customer. At least not yet