Invalid dateTime

[diego]

I am having problems when displaying in a DataGrid a value of type timeStampt, the value obtained in json is the following:

{"result":["date":"2020-03-12T13:49:03.615989"],"count":1}

My data grid column

  <e-grid-column field="date" headerText="date" type="dateTime"  textAlign="Right"></e-grid-column>

And the result shown on the grid:

Invalid date

[Sujith Kumar Rajkumar]

Hi Diego, 

Greetings from Syncfusion support. 

We checked your reported problem but unfortunately were unable to reproduce it from our end. Please check below sample for your reference, 

Sample: https://www.syncfusion.com/downloads/support/forum/152399/ze/GridApplication-926865199  

You can compare the above sample with your application to see if you have missed anything. 

It would be helpful to identify your problem better if you could share the following information, 

• Console error thrown(if any).
• Screenshot of reported problem.
• Syncfusion package version used.
• Grid code file.
• If possible provide us a simple sample to replicate the problem or try reproducing it in the above provided sample.

Note: If you are using old Syncfusion packages we suggest you to upgrade to the latest version and check if this resolves the problem. 

Documentation: https://ej2.syncfusion.com/aspnetcore/documentation/visual-studio-integration/nuget-packages/#upgrading-nuget-packages 

Let us know if you have any concerns. 

  

Regards, 

Sujith R 

[diego]

The problem comes from the collation of the DB or the value of the data, I explain: In netcore if I insert in BBDD it saves me for example:
03/16/2020 10: 18: 00.0123213 if I edit this value and save it without the milliseconds, it parses me correctly.

[Sujith Kumar Rajkumar]

Hi Diego, 

We could not clearly understand your query from the last update. Could you please explain in detail and share us the information requested in the previous update to further validate the reported problem from our end. 

Let us know if you have any concerns. 

Regards, 

Sujith R 

[diego]

Thanks I managed to solve the error, I had an error in the type of data in BBDD

[Sujith Kumar Rajkumar]

Hi Diego, 

We are glad to hear that you have resolved the problem. Please get back to us if you require any further assistance. 

Regards, 

Sujith R