Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Ivan
60
PivotGrid and DateTime Fields
posted

Hi,

  First of all sorry if I posted in the wrong newsgroup. I amtrying to use the Pivot Grid for the first time. I am populating a Datatable from my database and on of the fields is a DateTime. I then add the field to the Pivot grid using the code below

 PivotGridField myField = new PivotGridField("FlightDate", PivotArea.FilterArea);

myField.Caption = FieldTitle;

pivotGridControl1.Fields.Add(myField);

This works but the Field comes out as '12-31-2010 00:00:00' but i need to format the date to UK format with no time 'dd/MM/yyyy'. I tried to use the code below but with no luck

myField.CellFormat.FormatType = FormatType.DateTime

myField.CellFormat.FormatString = "d";

 

Am i doing something wrong or the date cannot be formatted