Date Problems - ASP/SQL

[Fawke101]

Hi there,

I have a date field in SQL server - that holds dates as DD/MM/YYYY format
(GB).

Now, i have an ASP application that Adds/Edits records in this table; and i
am having real problems with the date field in the ADD and EDIT (update)
part for this app.

Basically, i receive and Error as below:

****
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data
type to a datetime data type resulted in an out-of-range datetime value.
/add.asp, line 105
****

This occurs when i try to input a date in the format of DD/MM/YYYY through
an ASP Form. When i try it as MM/DD/YYYY it works great, I need it as GB not
US!

Any ideas how i can fix this?
I have already entered this at the top of the ADD/Edit page:

<%session.LCID= 2057%> (just a stab in the dark)

Any ideas much appreciated

--
Thanks in advance

Fawke

Please remove ANTI and SPAM
from my email address before emailing me.

www.bradflack.com

[Don Grover]

Just a mental reminder what the sql string composition is like.
Nullif checks for nulk and puts second parameter in if needed
Don

"Fawke101" <gu*@ANTIbradfl ack.SPAMcom> wrote in message
news:e7******** ******@TK2MSFTN GP09.phx.gbl...

Pucker.... thats great, cheers for that... works a treat

Just one thing - how come this is commented out? -

'---------
'sValues = " NULLIF('" & convdate(sDate) & "','')"
'---------

What does this part do exactly?
--
Thanks in advance

Fawke

Please remove ANTI and SPAM
from my email address before emailing me.

www.bradflack.com