I am using a Microsoft access database to store entries for a photo album. The database has a separate cell with date of the pictures, in 01.12.99 format. I know that I can get around this issue by setting the field type to text instead of date, but I use the field for sorting. The PHP code displays the cell variable it pulls from the database ($Date) as 1999-12-01 00:00:00. I checked the internal PHP functions like Date, Mktime, etc, I don't think they handle this. Or am I wrong? Please help!