DateTime fields read as strings

[mistyblue17]

Kepler.gl looks super cool and I'm excited to be able to use it. After adding my data, my fields only show up as integers and strings, even my DateTime field. I've tried going back into LibreCalc to set the format to date, time, and custom YYYY/MM/DD HH:MM:SS format, but it still just comes through as a string after upload the UTF-8 CSV file.
SyracuseSiteData_Qonly_UTF-8.zip

[heshan0131]

@mistyblue17 our current date time checks doesn't cover YYYY/MM case yet and is always expect a time, However YYYY/MM/DD HH:MM should work. I added a column datetime_1 in your csv in YYYY/MM/DD HH:MM format and was able to create a time filter

SyracuseSiteData_Qonly_UTF-8_fix.zip

[mistyblue17]

Yes! That did the trick. Thank you!

[Philwang3]

Hi, I am planning to use it on a history visualization demo. May I ask how kepler.gl handle date time before christ(B.C. time)? Is it "-700-03-01" or "700-03-01 B.C./bc" or "0700-03-01 B.C./bc"?

[FDenker]

@Philwang3 were you able to solve this problem because I am having similar issues

[gudeso23]

Thanks, @heshan0131 heshan0131

I have the same issue with the date formats, how did u make the conversion? I was trying to do using ArcGIS Pro Date Convertor, but that did not resolve the issue. Ori