Environment
-
Metabase Version: v1.62.x
-
Database: Oracle
-
Question Type: Query Builder (Notebook Editor)
-
Export Type: XLSX (Dashboard Subscription)
Description
When a date/time column is configured in the Query Builder visualization settings with "Show the time" set to "Off", Metabase correctly displays only the date in both the question and the dashboard.
However, XLSX exports generated from dashboard subscriptions ignore this formatting and export the underlying timestamp instead.
Steps to Reproduce
-
Create a Query Builder question using an Oracle table containing a DATE/DATETIME field (e.g.
Created On). -
Open the column formatting options.
-
Configure:
-
Date Style: any
-
Date Separators: any
-
Show the time: Off
-
-
Save the question.
-
Add the question to a dashboard.
-
Create a dashboard subscription with XLSX attachments.
-
Open the attached XLSX.
Expected Behaviour
The exported XLSX should respect the column formatting used in the question and export:
20/01/2025
without the time component.
Actual Behaviour
The XLSX exports the underlying value including the timestamp, for example:
20/01/2025 10:27
even though the question and dashboard display only:
20/01/2025
Additional Information
-
The issue only affects the XLSX export.
-
The Query Builder visualization correctly hides the time.
-
This appears to be an export formatting issue rather than a data issue.
-
The original database field is used (not a custom SQL field).
Impact
Recipients of scheduled dashboard subscriptions receive Excel files containing timestamps that are intentionally hidden within Metabase. This causes confusion and results in exported data not matching what users see on screen.