Date Format Problem

[mohmehran]

I have experiencing a problem, for executing INSERT INTO and SELECT statements. I
have set the SQL Server settings default lang to British English. I have also set
the regional settings of my machine to 'dmy'. But still I have problems inserting
date fields using dmy format.

Am I doing wrong?
Thanks for your help.
[sig]<p>Mohammad Mehran Nikoo<br><a href=mailto:mohmehran@yahoo.com>mohmehran@yahoo.com</a><br>MCP with experience in VB, ASP, XML, SQL, COM[/sig]

 

[foxdev]

As an experiment, try setting:

SET DATEFORMAT dmy

immediately before the statement and see what happens. [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]