GGC MonthCalendar format

[Ryan Hardoon]

Hi,

The ggc "MonthCalendar"-CellType presents its value, by default, in "dd:MM:yy" format and I wish it to display "yyyy:MM:dd" format.

What's the propper way of doing that ?
(designer prop. grid / programatically)


Thanks in advance.

[haneefm]

Hi Ryan,

You can try this code snippet to set the format of the datetime column in a grid.

//For main table.
this.grid.TableDescriptor.Columns["ColumnName"].Appearance.AnyRecordFieldCell.Format = "yyyy:MM:dd";
//For nested table.
this.grid.GetTableDescriptor("childTableName").Columns["ColumnName"].Appearance.AnyRecordFieldCell.Format = "yyyy:MM:dd";

Best regards,
Haneef

[Ryan Hardoon]

Hi Haneef,

I tried the following formats (both in the designer and on Load):
"yyyyMMdd"
"yyyy:MM:dd"
"yyyy/MM/dd"
"yyyy-MM-dd"

None had any effect.



>Hi Ryan,

You can try this code snippet to set the format of the datetime column in a grid.

//For main table.
this.grid.TableDescriptor.Columns["ColumnName"].Appearance.AnyRecordFieldCell.Format = "yyyy:MM:dd";
//For nested table.
this.grid.GetTableDescriptor("childTableName").Columns["ColumnName"].Appearance.AnyRecordFieldCell.Format = "yyyy:MM:dd";

Best regards,
Haneef

[haneefm]

Hi Ryan,

Please try the attached sample and let me know if this helps.
GroupingDateTime.zip

Best regards,
Haneef