We have built an intranet site which is heavily date reliant and uses about 60 pages, most of which display date data in Text controls. The data is read from and written to a SQL2000 database using ADO.<BR><BR>The system was built and tested on NT4 SQL Server 7. The Web Server is the Database Server (only a small number of users and smallish database). When on NT4 Server the regional settings used a small date format of dd mmm yyyy. All the dates on the web pages then displayed in this format. An eleventh hour change by the client to Windows 2000 and SQL 2000 has caused a problem. All the dates are coming through as mm/dd/yyyy which is not acceptible to the client.<BR><BR>We have changed the regional settings (and default settings) on the Server to dd mmm yyyy, and the database to English British format. No help. We have tried LCID = XXXX, no good.<BR><BR>At this stage rewriting all the pages to use a custom date formatting routine is not realy an option. Anyone got any ideas???