Users have reported that the date format in a downloaded .xlsx file from Metabase is different from what is seen in the Question.
From what I can see, the date in the source data is a full timestamp, but in the end all we need is the date portion.
I configured the formatting as far ‘upstream’ as I can go in Metabase i.e. in the Data Model field settings (put the ‘Show the time’ setting as OFF), but this formatting is not being preserved in the file download.
Is there any way around this?
(I thought I could create a ‘Custom column’ in the editor and put the correctly formatted date over there … but TBH I’m not sure what I’m doing.)
Formatting is not preserved in exports (nor pulses):
https://github.com/metabase/metabase/issues/10879 - upvote by clicking on the first post
And there’s currently a regression, which means that dates are exported with extra information:
https://github.com/metabase/metabase/issues/12964 - upvote by clicking on the first post