Access Dates Problem

I am running Access 97 Office SR-2b on Windows NT 4.0 Workstation SP6a.

I have the following code in a module:

sql = “SELECT *” _
& ” FROM tblWaitingTimes” _
& ” WHERE tblWaitingTimes![wtDate] = #” & oldDate & “#;”

where oldDate is a date in uk format of dd/mm/yyyy.

When processing this the statement shows the date in dd/mm/yyyy but the moves the day and month values around.

The system is set to UK date format with dd/mm/yyyy as the preferred choice.

I know the date is being transposed as I tried placing this in a query and running it.

How can I stop the system transposing the day and month values?