[CLOSED] date format

  1. #1

    [CLOSED] date format

    hi,

    The datetime in my gridpanel is not formating.. plz take a look below sample...

    <%@ Page Language="C#" %>
      
    <%@ Register Assembly="Ext.Net" Namespace="Ext.Net" TagPrefix="ext" %>
      <script runat="server">
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!X.IsAjaxRequest)
            {
                this.Store1.DataSource = this.Data;
                this.Store1.DataBind();
            }
        }
        private object[] Data
        {
            get
            {
                return new object[]
                {
                    new object[] { "3m Co", 71.72, 0.02, 0.03,Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "Alcoa Inc", 29.01, 0.42, 1.47, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "Altria Group Inc", 83.81, 0.28, 0.34, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "American Express Company", 52.55, 0.01, 0.02, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "American International Group, Inc.", 64.13, 0.31, 0.49, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "AT&T Inc.", 31.61, -0.48, -1.54, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "Boeing Co.", 75.43, 0.53, 0.71, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "Caterpillar Inc.", 67.27, 0.92, 1.39, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "Citigroup, Inc.", 49.37, 0.02, 0.04, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "E.I. du Pont de Nemours and Company", 40.48, 0.51, 1.28, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "Exxon Mobil Corp", 68.1, -0.43, -0.64, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "General Electric Company", 34.14, -0.08, -0.23, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "General Motors Corporation", 30.27, 1.09, 3.74, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "Hewlett-Packard Co.", 36.53, -0.03, -0.08, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "Honeywell Intl Inc", 38.77, 0.05, 0.13, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "Intel Corporation", 19.88, 0.31, 1.58, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "International Business Machines", 81.41, 0.44, 0.54, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "Johnson & Johnson", 64.72, 0.06, 0.09, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "JP Morgan & Chase & Co", 45.73, 0.07, 0.15, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "McDonald\"s Corporation", 36.76, 0.86, 2.40, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "Merck & Co., Inc.", 40.96, 0.41, 1.01, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "Microsoft Corporation", 25.84, 0.14, 0.54, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "Pfizer Inc", 27.96, 0.4, 1.45, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "The Coca-Cola Company", 45.07, 0.26, 0.58, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "The Home Depot, Inc.", 34.64, 0.35, 1.02, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "The Procter & Gamble Company", 61.91, 0.01, 0.02, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "United Technologies Corporation", 63.26, 0.55, 0.88, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "Verizon Communications", 35.57, 0.39, 1.11, Convert.ToDateTime("11/30/2010 7:51:31 PM") },
                    new object[] { "Wal-Mart Stores, Inc.", 45.45, 0.73, 1.63, Convert.ToDateTime("11/30/2010 7:51:31 PM") }
                };
            }
        }
    </script>
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"  
        "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
    <html xmlns="http://www.w3.org/1999/xhtml"> 
    <head id="Head1" runat="server"> 
        <title>Ext.Net Example</title> 
      
        <script type="text/javascript"> 
            var valCallOut = function () { 
                var result = true; 
                Ext.ComponentMgr.all.each(function(f) {  
                    if (f.isValid && !f.isValid(true)) {  
                        f.focus(); 
                        result = false; 
                        return false;  
                    }  
                }); 
                return result; 
      
            } 
        </script> 
    </head> 
    <body> 
        <form id="Form1" runat="server"> 
        <ext:ResourceManager ID="ResourceManager1" runat="server" /> 
        
        <ext:GridPanel 
            ID="GridPanel1"
            runat="server" 
            StripeRows="true"
            Title="Array Grid" 
            TrackMouseOver="true"
            Width="600" 
            Height="350"
            AutoExpandColumn="company">
            <Store>
                <ext:Store ID="Store1" runat="server">
                  <AutoLoadParams> 
                                    <ext:Parameter Name="start" Value="0" Mode="Raw" /> 
                                    <ext:Parameter Name="limit" Value="5" Mode="Raw" /> 
                                    </AutoLoadParams>
                                    
                    <Reader>
                        <ext:ArrayReader>
                            <Fields>
                                <ext:RecordField Name="company" />
                                <ext:RecordField Name="price" Type="Float" />
                                <ext:RecordField Name="change" Type="Float" />
                                <ext:RecordField Name="pctChange" Type="Float" />
                                <ext:RecordField Name="lastChange" Type="Date" />
                            </Fields>
                        </ext:ArrayReader>
                    </Reader>
                </ext:Store>
            </Store>
            <ColumnModel ID="ColumnModel1" runat="server">
                <Columns>
                    <ext:Column ColumnID="Company" Header="Company" DataIndex="company" />
                    <ext:Column Header="Price" DataIndex="price">  
                    </ext:Column>
                    <ext:Column ColumnID="Change" Header="Change" DataIndex="change">                   
                    </ext:Column>
                    <ext:Column Header="Change" DataIndex="pctChange">                   
                    </ext:Column>
                    <ext:DateColumn Header="Last Updated" DataIndex="lastChange" >
                     <Renderer Handler="return Ext.util.Format.date(value,'M d, Y h:m:s a');" />
                    </ext:DateColumn>
                </Columns>
            </ColumnModel>
            <SelectionModel>
                <ext:RowSelectionModel ID="RowSelectionModel1" runat="server" SingleSelect="true" />
            </SelectionModel>
              <BottomBar>
                                                    <ext:PagingToolbar ID="clpgtbDelIns" runat="server" StoreID="Store1" PageSize="5">
                                                    </ext:PagingToolbar>
                                                </BottomBar>
        </ext:GridPanel>
        
        
        <ext:TextField ID="TextField1" runat="server" AllowBlank="false" /> 
        <ext:TextField ID="TextField2" runat="server" AllowBlank="false" /> 
        <ext:Button ID="Button1" runat="server" Text="Is this valid?"> 
            <Listeners> 
                <Click Handler="alert(valCallOut());" /> 
            </Listeners> 
        </ext:Button> 
        </form> 
    </body> 
    </html>
    Last edited by geoffrey.mcgill; Dec 06, 2010 at 4:15 PM. Reason: [CLOSED]
  2. #2
    You can set the .Format property of the <ext:DateColumn>.

    Please use .NET DateTime format specifiers in the .Format property.

    Hope this helps.
    Geoffrey McGill
    Founder
  3. #3
    Hi majestic,

    Please note that <Renderer> doesn't make sense when it deals with <ext:DateColumn>. There is a special renderer like this one that you defined.

    So, please use .Format property as @geoffrey.mcgill mentioned or you could use your Renderer within a common <ext:Column>.

    Example
    <ext:Column Header="Last Updated" DataIndex="lastChange">
        <Renderer Handler="return Ext.util.Format.date(value,'M d, Y h:m:s a');" />
    </ext:Column>
    See also
    http://dev.sencha.com/deploy/dev/doc...rid.DateColumn

Similar Threads

  1. Replies: 3
    Last Post: May 09, 2012, 4:28 PM
  2. Replies: 1
    Last Post: Apr 13, 2012, 1:52 PM
  3. Replies: 4
    Last Post: Jun 30, 2011, 3:30 PM
  4. [CLOSED] How to Set Date Format in a Coolite Date Field
    By speedstepmem3 in forum 1.x Legacy Premium Help
    Replies: 2
    Last Post: Dec 02, 2010, 8:47 AM
  5. date format for all date fields in grid?
    By marcmvc in forum 1.x Help
    Replies: 0
    Last Post: Dec 01, 2009, 3:41 PM

Posting Permissions