I have a Subscription database running and i am trying to insert values into it from an ASP web form when i click on a button with an id of 'confirm'. The name of the field is 'startdate' (date data type) and i need to enter today's date into that record but everytime i do it comes with an error message:
"Exception Details: System.Data.SqlClient.SqlException: Conversion failed when converting date and/or time from character string."
The name of the table is 'Subscription' and I am using Visual Basic as my programming language.
Any help would be much appreciated.