Current filter:
                                You should refresh the page.
                                Support Center
                                0
                                  • 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.

                                    Thanks,
                                    Siva

                                0

                                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.

                                Thanks,
                                Alex

                                To start a chat you should create a support ticket


                                If you need additional product information, write to us at info@devexpress.com 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, Silverlight, ASP.NET, WinForms, HTML5 or Windows 8, DevExpress tools help you build and deliver your best in the shortest time possible.

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