Re: [INTERFACES] ODBC DATE PROBLEM

I am not sure about Access but I use ODBC from Excel and VB.

I leave my backend in default date mode (US private format) but rely on the
ODBC driver to switch itself to ISO format (as I recall, this approach was
decided by consensus a few months back).

In VB, this seems to be converted to whatever I select in the Control Panel
Regional Settings.

Sometimes I also use the VB Format function to manipulate the raw input format.

HTH,
Stephen.


========================================================================
Stephen Davies Consulting                                            scldad@sdc.com.au
Adelaide, South Australia.                                             Voice: 61-8-82728863
Computing & Network solutions.                                     Fax: 61-8-82741015