Date format issues

Please refer to this JS fiddle: https://jsfiddle.net/67yx16ec/31/

It has been created specifically to demonstrate the issue we are having.
Run the fiddle and create and import the below CSV file:

id,name,dob_with_time,dob,only_time,country
1,John,1968-06-11 03:03:10,1968-06-11,03:03:10,India
2,Jane,1988-02-21 13:03:10,1988-02-21,13:03:10,UK
3,Michael,1993-04-06 21:03:10,1993-04-06,21:03:10,USA

Now click on ‘export’ to export the table in EXCEL format.

We are trying to find a solution to the following issues:

  1. Date or DateTime columns are not treated as a date unless you explicitly edit the cell or change the format to Date/DateTime. Due to this, it is not possible to apply a filter to filter rows by a specific year, month or date in excel.
  2. It is not possible to add up the hours / create a SUM of hours (column ‘only_time’) unless I explicitly edit those cells or change the data type

Hope the questions are clear. Please let us know if there is a way to resolve the issue.

Thanks.
 

4 answers

Public
Tanya Gryshko Flexmonster May 31, 2018

Hello, Mandar,
Thank you for the question and detailed description.
We will investigate the issue and check if it’s possible to change the type of the cells. I will provide you with the estimates soon.
Regards,
Tanya

Public
Tanya Gryshko Flexmonster May 31, 2018

Mandar,
I’ve added this fix to our wishlist for the next build. The fix will be available in the minor release 2.5.5 (ETA June 18)
Thanks,
  Tanya

Public
Mandar Dixit May 31, 2018

Thanks, Tanya. This is a critical piece of functionality for us, so happy to hear that a solution is being planned. Looking forward to the 2.5.5 release.
 
Kind regards,
Mandar

Public
Tanya Gryshko Flexmonster 5 days ago

Hello, Mandar,
We are glad to inform you that the new version of Flexmonster has already been released. Now when exporting datetime data to Excel, Excel also shows the time part and treats it like a date. time data is treated like Time in Excel now. The recommended approach to use it: apply ds+ type ("date string" for JSON) to have a simple date, apply dt+ type ("datetime" for JSON) to have datetime, apply t+ type ("time" for JSON) to have time data.
You’re welcome to update the component.
Regards,
Tanya

Please login or Register to Submit Answer