Invalid date format exporting drill down to Excel

Hello Igor,

Thank you for reporting the issue and providing all the necessary information. 

We will take a look at the described behavior and provide a fix with our minor release with an ETA May 1st. Our team will notify you about the release.

You are welcome to reach out to us in case other questions arise.

Kind regards,
Nadia

Hello,

Thank you for the response.

As a temporary workaround, you can create multiple fields from one field using Mapping and use them separately in the slice. For example,

mapping: {
   "Date3": [{
            uniqueName: "datetime_count",
            type: "datetime",
            caption: "Date (datetime)"
          },
          {
            uniqueName: "datetime_export",
            type: "datetime",
            caption: "Date (datetime)"
          },
    ]
}

Then, we suggest pre-defining the slice for the drill-through view and replacing the current date field with the created one:

drillThrough: [
        "Date2",
        "datetime_export",
]

These values will look the same but be exported in the correct format. Please note that the pre-defined slice for the drill-through view will be applied to all the values. You are welcome to check the following JSFiddle for reference: https://jsfiddle.net/flexmonster/faub51dh/ 

Feel free to contact us in case further questions arise.

Kind regards,
Nadia

Hello Igor,

We are pleased to inform you that the issue with formatting datetime fields when exporting to Excel in the drill-through view was fixed.

This fix is included in the 2.9.50 version of Flexmonster: https://www.flexmonster.com/release-notes/version-2-9-50/ 

You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/

Please tell us if the fix works. Looking forward to hearing from you.

Kind regards,
Nadia

Hello Igor,

Thank you for your feedback.

We are glad to hear that it works for you!

As always, feel free to contact us in case further questions arise.

Kind regards,
Nadia