Hi everyone,
We are experiencing difficulties when we're importing CSV file into an custom entity. String, double and integer types are imported but we can't figure out the string format for the datetime type !
Can somebody help us ?
TIA !
Hi everyone,
We are experiencing difficulties when we're importing CSV file into an custom entity. String, double and integer types are imported but we can't figure out the string format for the datetime type !
Can somebody help us ?
TIA !
I believe you need to supply datetimes in the "yyyy-MM-ddTHH:mm:ss" format - don't forget the "T" in between the date & time.
This is the standard XML date format: www.w3schools.com/.../schema_dtypes_date.asp
I tried this format but I used DateTime.Parse() function on the string. That function killed the "T".
Anyway, it work now ! Thanks for the quick answer !
*Community Hub is the new name for Sage City