🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Date format in drill through

Sangamesh asked on August 19, 2019

I am using D4+ to get date hierarchy in my report.
Ex -> Year (2 records total)
              -> Quarter
                             -> Month
                                           -> Day
                                                          (2 records)
But in drill through and excel download I am seeing (2019 / Quarter 2 / April / 2).
But what I want to see is real date (dd/mm/yy) with date type for each records in rows.

3 answers

Dmytro Zvazhii Dmytro Zvazhii Flexmonster August 19, 2019

Hello Sangamesh,
Thank you for posting your question here.
Currently, the date pattern for ‘D4+’ dates in the drill-through pop-window is not available.
As a workaround, we recommend using customizeCell approach: https://www.flexmonster.com/api/customizecell/. You can change the format of the date cells in the drill-through window. The obtained result should be exported to Excel as expected.
Please let us know if you have any other questions.

Sangamesh August 20, 2019

Using customizecell I was able to achieve the format from (year/quarter/month/day) to (month/day/year).
I used pop() and unshift() with trim(). I found this in another thread in this forum.
But what we are looking for is (dd/mm/yy) in ISO format. Actually when we download the excel sheet it should show in Date Type so that we can sort the dates.

Ian Sadovy Ian Sadovy Flexmonster August 21, 2019

Hello Sangamesh, 
It sounds like a nice feature to have, but currently, drill-through export for D4+ does not support Excel date format.
Please note, that ds+ (date string) type supports exporting Excel dates.
You can check how it works here: https://jsfiddle.net/flexmonster/yrcpdg45/
Hope it helps.

Please login or Register to Submit Answer