Importing dates into a data grid

James Rivera shared this question 6 years ago
Answered

I am using the import feature to populate the fields in a data grid, however, the import will not import any data into the date fields execpt for those dates formatted at 11/11/2011?

Comments (3)

photo
1

Yes, now that's the only format accepted for 'date' types. If you want to accept any format then you must change the attribute in your data master from 'date' to 'text.

photo
1

So I want to import dates such as 03/01/2011, however, it will not import any date that has less than 2 digits and it ignores the 0, so these will not import as a date?

photo
1

Yes, it's a bit fussy.