Format a date in VB.net

[venerable bede]

I have a calendar control which populates a textbox.
The date is in American format e.g "MM/DD/YYYY"
I need to convert this into "YYYY-MM-DD" so that I can insert it into a MYSQL database.

ANy ideas ?

I hate dates


TIA

[Pirate]

Try this :

TextBox1.Text() = Format(Now.Today(), "MM,dd,yyyy")

[venerable bede]

You never seem to let me down Pirate.

Cheers :-)

[alex_read]

Just my 2 cents worth but I picked this up from the net last week - you can specify the date formatting after the ".tostring" call for another time...

Now.ToString("dd/mm/yyyy")

[MrGTI]

Couldn't you just assign the date value to the OleDbCommand object and let ADO.NET do the rest for you?

.Parameters.Add(New OleDb.OleDbParameter("@MyBirthdateField", OleDbType.Date))