>Hi Borislav, thanks for your time, the problem is, the users enter the dates manually into text boxes (and there are dozens of them !) so how can I use ANSI ?
You must convert it in your front end before send it to the SQL Server.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.