MS Access, php and dates...

[morrislgn]

Hi, how is it going?

I am having a problem extracting date information from Access using a DNS less connection.

Here is the code which I am using to connect to the database:

$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$db");

#$date is today's date
$date = date("d/m/Y");

$sql = "SELECT events.Date, events.Links, events.Event, events.Descripton, events.Location FROM events WHERE (((events.Date)>$date)) ORDER BY events.Date";
$rs = $conn->Execute($sql);

The following code is being used to output the information to the browser:

<td><font face="verdana" size="2" color="#007AC0"><?= $rs->Fields['Date']->Value ?>:</font></td>

However, instead of displaying the date in the same format as that stored in the database, 05/12/2004 the date is displayed as 1102809600.

I have tried different ways of delimiting te date using #'s etc, but they dont seem to work.

Any ideas?

Thanks

Morris

[harlowhair]

When working with non-MySQL databases I find it easiest to convert the date to a Julian day count using the gregoriantoJD function.

the date can then be stored as a number and easily converted back in the PHP code