Hi,

Just looking to your code; I thought you are storing date and time value in your database. If so, why are you using textbox. Use datetime control. It will solve your problem. One more thing is check the format for date and time. If you wanna save date and time; U must format them as needed by the database settings.

like :

table(0).Fields (0).value = Format(dtpdate. value,"dd-mm-yyyy")
...