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.
⋅ 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.
Regards,
Dmytro
⋅ 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.
⋅ 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.
Regards,
Ian
