I have a table that stores 2 seperate dates in there own columns, one is called date opened and the other is called date closed in the MySQL table.
I use PMI to insert records into the table, when I insert the record I enter a date in the date opened column.
Then when I view the table in PMI the date opened column is correct, but I also have the date “Dec 31, 1969” showing up on the date closed which is set to “NULL”.
When I check the table in MySQL the date closed column reads only “NULL”
Any ideas on where this date is coming from?