Home
Changelog
Data Importer - now with DateTime datatype support
new
AuraDB Professional
AuraDB Free
Data Importer
This release of Data Importer brings support for the DateTime datatype. You can now update your existing model configuration to use the DateTime datatype or if you're creating new properties from file columns, we will attempt to autodetect them for you.
CleanShot 2022-10-12 at 13
The DateTime support is designed to require minimal user input, so there's no need to specify a date format. Behind the scenes we achieve this by using JavaScript's lenient date parsing which takes a best guess at how to parse the string. You should be aware of the limitations of lenient date parsing, where ambiguous (eg US vs GB day/month ordering) or specific date formats having the potential to lead to unexpected results. If you want to be 100% confident your DateTimes will be handled correctly in Data Importer, you can guarantee this by ensuring your date is in ISO 8601 format
YYYY-MM-DDTHH:mm:ss.sssZ
or one of its variants:
  • 2011-10-10
    (date-only)
  • 2011-10-10T14:48:00
    (date-time)
  • 2011-10-10T14:48:00.000+09:00
    (date-time with milliseconds & timezone)
As always, we look forward to hearing feedback, so please head on over to our feedback board and leave us a post with any comments.