format time

[reta]

hi
i currently allow the users to enter in a time value of hh:mm and i have a javascript that validates the data.

The problem is i would like to input this data into sql database but an error comes up by not enabling the ':' to be inputted into by smalldatetime field. So i would like to format this data to go into that field before it enters into the db.
Thanks
reta

 

[jbenson001]

What is your code? What is the error you are getting? How does the input look when the user enters data?

Jim

 

[jbenson001]

Also, you can't just enter a time, you will need a date as well. You can use some dummy date if you need too.

Jim