2. PHPRunner General questions
  3. [SOLVED]  Date upload
This topic is locked
[SOLVED]

 Date upload

 		12/16/2011 11:36:16 AM
PHPRunner General questions
author

Hi
When I upload my dates to my database all the dates are uploaded incorrectly. I am using PHPrunner 6 and have set the region and date settings to US. My spread sheet is using american date format MM/DD/YYYY (I am sure that is correct)
So i upload

12/11/2011
12/02/2012

12/03/2012
and the date is changed to in my database table
2011-12-11

2002-12-12

2003-12-12
I have never used the upload feature before. How upload the US date format and it import correctly?
Thanks in advance
Regards
C
 		cgphp 12/17/2011

YYYY-MM-DD is the mysql date format.
7542 12/17/2011

Cristian,
I am not sure what happened but I fixed it 2 minutes ago.
I changed view as values to short date in the american format the upload works perfectly and it automatically translates the date to yyyy-mm-dd. It now works for long and short dates. I assume that the date format might had a error as i changed the date from uk - us. I guess I should have reset all the dates. Anyway, its working now. Thanks.
Regards
Richard