I am using your grid control to show database query results
The date times are stored in my SQLite database in W3C / ISO 8601 format e.g.
and I have one of my columns set up as below as I want to see date on screen as dd/MM/yyyy HH:mm:ss[VB.NET]
Dim gcArchive1 As GridColumn = GridView_Archive.Columns.AddField("TimeCreated") gcArchive1.Caption = "Time Created" gcArchive1.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime gcArchive1.DisplayFormat.FormatString = "dd/MM/yyyy HH:mm:ss"
But it doesn't seem to work as grid shows
when I want
To achieve the desired value formatting, create RepositoryItemDateEdit, assign it to your gcARchive1 column, and adjust its settings as follows:
Dim de As New RepositoryItemDateEdit() de.Mask.EditMask = "dd/MM/yyyy HH:mm:ss" de.Mask.UseMaskAsDisplayFormat = True gcArchive1.ColumnEdit = de
This way, everything should work as expected. Please try this approach and let me know if it works for you.