Current filter:
                                You should refresh the page.
                                Support Center
                                  • Hi,
                                     How do I format a Date column in a Pivot Grid? I want column to show up entries like 01/31/2011. I tried this

                                                        field.CellFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
                                                        field.CellFormat.FormatString = "MM/dd/yyyy";

                                    It did not work. If you have a quick fix or code snippet, It would be of great help.



                                Hi Siva,

                                Thank you for posting your code snippet. If you wish to apply a custom format to Field Values, you will need to adjust the PivotGridFieldBase.ValueFormat property. Please refer to the DateTime format strings ticket for a sample project that illustrates this approach in action.


                                If you need additional product information, write to us at or call us at +1 (818) 844-3383

                                FOLLOW US

                                DevExpress engineers feature-complete Presentation Controls, IDE Productivity Tools, Business Application Frameworks, and Reporting Systems for Visual Studio, along with high-performance HTML JS Mobile Frameworks for developers targeting iOS, Android and Windows Phone. Whether using WPF, ASP.NET, WinForms, HTML5 or Windows 10, DevExpress tools help you build and deliver your best in the shortest time possible.

                                Copyright © 1998-2017 Developer Express Inc.
                                All trademarks or registered trademarks are property of their respective owners