I have tried this a ton of different ways and still no good. I have 3 date fields in an excell sheet i want to import. When i import them useing a customer script there is no issue they are on the excel sheet as 2007/11/28. But when there imported with the Importer built into phprunner they come out as 1969/12/31. Has anyone encoutered anything like this? or is there a way i need to setup my excel template to avoid this.... Im importing into MySql the column is as a Date column.
i have realized the 1969 date is becuase the importer cannot read the date listed where can i or even can i edit the formats of the dates. i have added the following to the Excel reader.php file with no success.
0xa => "yyyy/mm/dd",
0xb => "dd/mm/yyyy",
0xc => "mm/dd/yyyy",
0xd => "y/m/d",
any help would be appreciated.
thanks