Some relative date filters don't work for custom expression columns

[ranquild]

Describe the bug

When using a relative date filter based on a column coming from a custom expression, we get "No results" while there are results for the selected range.

To Reproduce

1. New -> Question
2. Sample Database -> Orders
3. Add a custom column Date with expression [Created At]
4. Filter -> Date -> Relative dates -> Current -> Quarter
5. Visualize
6. See "No results" message
7. Do the same with just Created At column
8. You would get results

Regular column:

Custom column:

Expected behavior

The results should be the same as if the underlying column was used

Logs

No response

Information about your Metabase installation

{
  "browser-info": {
    "language": "en-US",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.16+8-LTS",
    "java.vendor": "Azul Systems, Inc.",
    "java.vendor.url": "http://www.azul.com/",
    "java.version": "11.0.16",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.16+8-LTS",
    "os.name": "Mac OS X",
    "os.version": "12.1",
    "user.language": "en",
    "user.timezone": "Asia/Jerusalem"
  },
  "metabase-info": {
    "databases": [
      "h2"
    ],
    "hosting-env": "unknown",
    "application-database": "h2",
    "application-database-details": {
      "database": {
        "name": "H2",
        "version": "2.1.214 (2022-06-13)"
      },
      "jdbc-driver": {
        "name": "H2 JDBC Driver",
        "version": "2.1.214 (2022-06-13)"
      }
    },
    "run-mode": "dev",
    "version": {
      "date": "2023-11-03",
      "src_hash": "5529b6543b1b3382e1c7195c270b43e72688782f",
      "tag": "v0.48.0-SNAPSHOT",
      "hash": "e5bc88b"
    },
    "settings": {
      "report-timezone": null
    }
  }
}

Severity

P2

Additional context

No response