Funky date format

[woodtv]

Hi all,

I'm converting excel spreadsheets into mysql; however, the probelm is that the date from the excel spreadsheet is formated as such: 30503

This would express March 5, 2003. The format doesn't jive with strtotime.

Any ideas on how to get this type of date formatting to play a little more nicely?

Any help getting this to a MySQL format would be great.

Thanks!

[statrat]

YYMMDD is a valid mysql date format, so if you knew you would always get a date in this format from excel (5 or 6 numbers), you could reverse that excel date.

 $date='30503';

$month=substr($date, 0, strlen($date)-4);
$day=substr($date, -4, 2);
$year=substr($date, -2);

if(strlen($month)==1) $month='0'.$month;

$mysqldate= $year.$month.$day;
echo $mysqldate; 

[woodtv]

than.x statrat!

that was perfect.

sometimes you just can't see the ketchup bottle in the fridge until someone else opens the door.

than.x