Date Format 1

[Linda224]

Hello All
I am trying to have the date in a gridview displayed as

Thursday 3/15/2007

Any idea on how to get the day of the week to show?

Thank you

 

[jebenson]

I'm not sure if this will work for a DataGridView, but for a DataGrid it can be done like this:

Dim ts As DataGridTableStyle = New DataGridTableStyle

ts.MappingName = "<YourTableNameHere>"

DataGrid1.TableStyles.Add(ts)

With DataGrid1.TableStyles(0)
Dim dgtbc2 As DataGridTextBoxColumn
dgtbc2 = CType(DataGrid1.TableStyles(0).GridColumnStyles(4), DataGridTextBoxColumn)

If Not dgtbc2 Is Nothing Then
dgtbc2.Format = "dddd MM/dd/yyyy"
End If
End With

Notes:

In this line - ts.MappingName = "<YourTableNameHere>" - use the name of the table being dusplayed in place of <YourTableNameHere>

In this part -GridColumnStyles(4) - replace the "4" with the correct index of the column you want to format.

If nothing else, just know that the format string to display a date like "Thursday 3/15/2007" is "dddd M/d/yyyy"

Hope this helps.



I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day! Ye has a choice: talk like a pira

 

[Linda224]

Thank You!!!!
It was just the dddd mm/dd/yyyy that i needed

 

[jebenson]

It was just the dddd mm/dd/yyyy that i needed

Just to clear, the months part of the format string is a uppercase 'M', not lowercase. A lowercase 'm' formats minutes.



I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day! Ye has a choice: talk like a pira