I try to import excel file that has 2 column → Name and Birthdate. In the BirthDate column the data has format yyyy-mm-dd hh:mm:ss.
And When I import to NocoDB there’s an error show in the image below
I change datetime format in various type such as dd/mm/yyyy hh:mm:ss but nothing works. If I import in singleLineText format in noco. The data in table is changed that there’re “T” between date and time and “.000Z” in the suffix. Please guide me how to fix it.