DataGridView date format

[wooody1245]

I have a DataGridView that gets its data from a DataSet. Everything looks great except for the dates. All dates are formatted like this 2007-06-08T09:58:46.33-05:00. I would like to display the date like this: 06/08/2007 09:58 AM. I've tried formatting the datetime within the SQL query but I'm not having any luck. Anytime I return a type of datetime, no matter how I format it within the SQL query, it gets returned as 2007-06-08T09:58:46.33-05:00.

 

[jmeckley]

dataGridView1.Columns["MyDate"].DefaultCellStyle.Format="MM-dd-yy HH:ii:ss";

for more info on formatting dates check out this msdn article

Jason Meckley
Programmer
Specialty Bakers, Inc.