How to convert a text to a smalldatetime

[ndevriendt]

Hello

I'm working with VB and SQL Server.

I have a table with a field open_time of the type smalldatetime.

In VB I have a data textbox where datamember property contains the value "open_time". De dataformat property
contains the value "Time".

I get an error when I make a change and save my changes with recordset.update. The error tell me that there is a overflow when converting to smalldatetime.

I receive the same error when I save a value with the function Cdate(text) in the field open_time.

Can somebody help me ?

Thanks for your time and answer

Devriendt Nico

 

[johpje]

Nico,

I think its because VB and SQL are set up to use different formats of date. if you try to convert from dd/mm/yyyy to mm/dd/yyyy, it will return a wrong date or an error if the day is greater than 12.
You'll have to find the correct format that's needed by SQL Server. In VB you can create this correct syntax with the format function. ex: Format(Date(), "dd/mm/yyyy hh:mm&quot

Good luck
Johpje