Date format issues

posted on May 30th, 2018

Answered

Mandar Dixit asked on May 30, 2018

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:

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.
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.

7 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 ⋅ June 19, 2018

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

Public

Mandar Dixit ⋅ June 28, 2018

Thanks, Tanya. The dates are now appearing as dates in excel which is great, however, we are still not able to add up hours when exported (Please refer to point #2 in my original post).

Public

Tanya Gryshko ⋅ Flexmonster ⋅ June 29, 2018

Hello, Mandar,
I'm glad that dates export works fine for you.
Regarding the ability to add up hours when exported, thank you for informing us that it does not work on your side. Our development team will release an update with a fix on July the 16th.
Also, I would like to inform you that time should be specified in seconds in the data source. Here is an example of time specified in CSV file:

t+time
122

Inside Flexmonster, such time will be displayed as 00:02:02.
Please let me know in case of questions!
Regards,
Tanya

Public

Dmytro Zvazhii ⋅ Flexmonster ⋅ July 18, 2018

Hello Mandar,
We have released the update for the time data. Now, the time data from Flesmonster is treated as numeric data in excel. You are welcome to try it in the latest version.
Please let us know if everything works as expected.
Regards,
Dmytro

Date format issues

7 answers

Please login or Register to Submit Answer