Dates incorrectly displayed after Look is downloaded to Excel - Unparseable date

I think something goes on terribly wrong with the Looker development cycle. The latest minor 22.6 release broke the patch of this issue from the previous release. The issue is quite severe, but Looker has been fixing it for almost two months. Also, I think using terms like “Legacy” for stable things is confusing, notably with notification that it’s going to be removed regarding the default feature being too buggy.

Legacy Query Streaming in 22.6 hast note “This feature will be permanently removed upon upgrade to Looker 22.8, which becomes available about 9 days from now.”, but the actual one is still unstable.

2 Likes

Anyone got an update? I’ve ‘automated’ some Looker reports into Google Sheets but they require date formatting each time - hardly automated now, it’s still requiring my time to modify the date format.

Please let me know when this fix will be in place.

Hi,

This is not solved at all;

  • Excel format - I get Unparseable date
  • CSV - its correct BUT instead of ‘€’, I get the following symbols ‘€’, which creates another problem ?

can someone look into this please?

Regards

Stefan

The “Best answer” no longer works as the legacy feature was removed. This issue should be un-marked as “Solved” as the new feature is broken.

Currently there’s no way to correctly export dates in Looker which seems pretty critical to me…

agreed @djdevin and thanks