-
Notifications
You must be signed in to change notification settings - Fork 536
Description
Describe the bug
A column in firetable is configured with the DATE type. When importing a CSV file with date data into this field, the result is "Something went wrong" is displayed. Several different date formats have been tried.
To Reproduce
Steps to reproduce the behavior:
- Create a firetable with a column of type DATE
- Import a csv file with a column having data in a date format into this DATE column. The following formats have been attempted:
- m/d/yy
- mm/dd/yy
- mm/dd/yyyy
- month day, yyyy
- yyyy-mm-ddT00:00:00.000Z
- yyyy-mm-ddT00:00:00Z
- The import will be successful but the firetable will display "Something went wrong" for this date value.
After manually entering a record into the firetable, we reviewed the data being stored via firebase and the date value is being stored as a timestamp instead of just a date. Exported the table data to confirm the format from an export and it is yyyy-mm-ddT00:00:00.000Z which is one of the formats listed above that was tried for importing.
Expected behavior
Firetable import will accept any date format, or a defined date format that is supported for import needs to be identified.
Desktop (please complete the following information):
- OS: macOS 10.14.6
- Browser: Safari
- Version: 13.1