This topic is locked
[SOLVED]

 Problems In The Date Format When Importing Excel:

1/8/2013 8:38:06 PM
PHPRunner General questions
J
joiresende author

I am using an excel table to import various data. I have sometimes problem with importing date format. In my country we use the format dd / MM / YYYY, if I do not change the date format to 14-Mar-01, after importing the date format is MM / DD / YYYY. Would there be a way to ensure that every time I import the excel table the date format is the standard of my country who is DD / MM / YYYY. I use a MYSQL database.

Admin 1/9/2013

I recommend to check BeforeInsert event:

http://xlinesoft.com/phprunner/docs/before_insert_record.htm
This is where you can convert date values to another format. Please note that internal database format is yyyy-mm-dd. This is how you need to format dates before inserting.