Date Formats Import Requirements in RDM
Reported for version 10
How to correctly input datetime records in yyyy-MM-dd'T'HH:mm:ss.SSS date format
When having data of datetime format yyyy-MM-dd'T'HH:mm:ss.SSS, the correct way how to input them is without the apostrophes, e.g. 2016-01-01T00:00:00.000. The apostrophes in the format definition just differentiate the constant from variables and are not used for inputting data. Therefore it is necessary to remove them when preparing data for import (importing can be done via RDM Web Application > EDIT mode > Bulk).
Related articles