Date format different results

Get Help
1

Hello,

i have a problem with the date format. I get different results:

Data model:

Data%20model
Data%20model368×575 18.3 KB

Browser: only this display is correct
Date%20format%20Browser

Mail pulse:
date%20format%20in%20the%20mail

Excel download from the pulse:
date%20format%20pulse%20Excel

Excel download from browser:
date%20format%20download%20browser%20Excel

Is it possible to get the same result (dd.mm.yyyy) everywhere like i set in data model?

2

Hi @EcoIngo
Currently neither exports or pulses preserve formatting - upvote by clicking :+1: on the first post of each issue:
https://github.com/metabase/metabase/issues/10879
https://github.com/metabase/metabase/issues/3735

3

Hi Flamber,

but in previous versions i can download the xlsx file and the date was nearly correct (for example 2020-01-16). Now there is always a timestamp at the end and the format is mm.dd.yyyy 00:00:00 (1.16.20 00:00:00). Is there any setting to get the date without a timestamp?

4

@EcoIngo

  1. Post “Diagnostic Info” from Admin > Troubleshooting
  2. Which database are you querying and what is the database column type of Datum?
  3. Which previous version where you using?