Date field not being recognized on CSV upload
Posted: 2019-07-15 18:48
Hi,
I have one table that one field is called event date, the field type is setup as date, when I try to upload other events thru the csv utilty to upload in appgini it doesn't upload the event dates for the rest of the events even though that is able to upload the rest of the fields even the time fields correctly. I'm positive that I'm using the correct format as I am downloading first the table as a CSV from appgini to make sure that it recognize the CSV format. I also have the "use 24 hr time format" unchecked on the appgini defaults.
When I went to PHPMyAdmin the date field is changed to: 0000-00-00
Can anyone please tell me why the event date is the only field that is not uploading and the rest of the fields are uploaded correctly?
I have one table that one field is called event date, the field type is setup as date, when I try to upload other events thru the csv utilty to upload in appgini it doesn't upload the event dates for the rest of the events even though that is able to upload the rest of the fields even the time fields correctly. I'm positive that I'm using the correct format as I am downloading first the table as a CSV from appgini to make sure that it recognize the CSV format. I also have the "use 24 hr time format" unchecked on the appgini defaults.
When I went to PHPMyAdmin the date field is changed to: 0000-00-00
Can anyone please tell me why the event date is the only field that is not uploading and the rest of the fields are uploaded correctly?