When exporting to Excel, apply the date format of the column excluding start_date and end_date

Gantt
#1

When exporting the Gantt Chart to Excel, the date format is not applied if there is data in the date format in other columns except start_date and end_date.

i want to remove time from planed_end column.

Is there any way to solve it?

Here’s the example code.
https://snippet.dhtmlx.com/ifvd6n92

the export button is found by scrolling down.

Screen Shot
Screen Shot1027×169 4.54 KB

this is the result of export.

The actual value of Planned End is 2019-04-02 03:00 PM,
I would like to extract only the 2019-04-02 that removed the time as the actual value.

#2

I solved this problem by some expedient.

After creating and hiding a new column planned_end_text

just before exporting, string data was created using eachTask function and moment js.

after modifying to planed_end_text in exportOptions, I was able to obtain the output of the desired format by exporting.

Here is the modified source.

https://snippet.dhtmlx.com/z29iltoy

#3

Hello,
Thank you for letting us know about that issue. It seems that the issue is not related to the date_format property.
The custom columns with the date values have the dates stringified into the ISO format, and it means it depends on the current time zone. As a result, you can even get the value of a previous day instead of the actual value. The date_format property only confuses how it works.
I added it as a bug to our internal bug tracker. The dev team will fix the bug in the future, but I cannot give you any ETA.

1 Like