Metabase: We're incorrectly appending time to Date fields that don't have an explicit time

Created on 31 Aug 2017  路  3Comments  路  Source: metabase/metabase

According to @senior, we're using default behavior, which is giving Date fields a time of midnight. It's possible that this might be the root cause of issues like https://github.com/metabase/metabase/issues/4245.

:arrow_down: Please click the :+1: reaction instead of leaving a +1 or update? comment

CustomizatioFormatting P2 Bug VisualizatioChart Settings

Most helpful comment

This is a bit of an annoyance for us, as excel doesn't recognize dates like 2016-01-01T00:00:00.000Z

All 3 comments

~I think this also might be the root cause of #5743 as well.~ I take it back. That one has to do with how we format by-minute groupings.

This is a bit of an annoyance for us, as excel doesn't recognize dates like 2016-01-01T00:00:00.000Z

Also having this same issue, even when casting as date. Shows in UI and csv/xlsx downloads.

Was this page helpful?
0 / 5 - 0 ratings