Exporting Dates to MS Excel

[tgb417]

User Story:

As a Data Analyst, I'd like to be able to export Dataiku Datasets into MS Excel files and have the parsed Date Time come through into MS Excel as MS Excel DataTime Columns not Text strings in the style of an ISO Data Time, this would save time and reduce confusion on the part of date consumers.

Notes:

• Problem was discovered in Dataiku DSS V8.0.4

cc: @AshleyW 

[wjkelly]

Just adding a comment to be able to track the status of this feature request

[wjkelly]

Just adding a comment to be able to track the status of this feature request

[CoreyS]

Hi @wjkelly in the future please feel free to click on the 

 button on the top right. You can learn more about subscribing to ideas here, as well as Participating on the Product Ideas board. 

 

[CoreyS]

Hi @wjkelly in the future please feel free to click on the 

 button on the top right. You can learn more about subscribing to ideas here, as well as Participating on the Product Ideas board. 

 

[Turribeach]

Seems fixed in v11.1?

https://doc.dataiku.com/dss/latest/release_notes/11.html#enhancement-of-excel-exports

[Turribeach]

Seems fixed in v11.1?

https://doc.dataiku.com/dss/latest/release_notes/11.html#enhancement-of-excel-exports

[AshleyW]

We did it!

Your idea has become reality and has recently been delivered in 11.1. As @Turribeach pointed out, you can find more details in the release notes. In summary, when you now export a dataset to an Excel file, more storage types will be respected between the two: dates, strings with leading zeros, etc.

Take care,
Ashley

[AshleyW]

We did it!

Your idea has become reality and has recently been delivered in 11.1. As @Turribeach pointed out, you can find more details in the release notes. In summary, when you now export a dataset to an Excel file, more storage types will be respected between the two: dates, strings with leading zeros, etc.

Take care,
Ashley