Selecting the Date from the Calendar object

What is the date format your customer is inputting into the web form. There are naming conventions and standards that must be followed when inserting date objects on a db. You may have to programmatically manipulate the date captured on web application and then upload it to your db.

 

Hi All,



I have a problem in taking and inserting the Date of a Calndar object in the database:

Whenever I execute the following scripy I get "not a valid month"



uatSupportSource4x.InsertCommand = "INSERT INTO SUPPORT(TESTER_NAME, ACTIVITY, PROBLEM, SOLUTION, RELATED_EXCEPTION, PROB_DATE) VALUES ('" + TextBox1.Text + "', '" + DropDownList1.SelectedItem.Value.ToString + "', '" + TextBox2.Text + "' , '" + TextBox3.Text + "', '" + TextBox4.Text + "', '" + Calendar1.SelectedDate + "')"


Please assist,


Mahdi

 

By the way - It works fine when I put the following insteam of the calendar1.selectedDate:





TO_DATE('05/08/2007 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

By I need to use the calendar (the date that the user inputs)..