[CLOSED] mssql datetime can not convert to proper date format?

  1. #1

    [CLOSED] mssql datetime can not convert to proper date format?

    mssql column's type is datetime , its's data is {2014/2/14 19:46:51} can not conver to yyyy-MM-dd
    protected void Page_Load(object sender, EventArgs e)
            {
                if (!X.IsAjaxRequest)
                {
                    var cases = caseDao.AllCases();
                    store1.DataSource = cases;
                    store1.DataBind();
                }
            }
    <ext:GridPanel runat="server">
                        <Store>
                            <ext:Store runat="server" ID="store1">
                                <Model>
                                    <ext:Model runat="server">
                                        <Fields>
                                            <ext:ModelField Name="id"></ext:ModelField>
                                            <ext:ModelField Name="casename"></ext:ModelField>
                                            <ext:ModelField Name="pic"></ext:ModelField>
                                            <ext:ModelField Name="info"></ext:ModelField>
                                            <ext:ModelField Name="url"></ext:ModelField>
                                            <ext:ModelField Name="addtime" Type="Date"></ext:ModelField>
                                        </Fields>
                                    </ext:Model>
                                </Model>
                            </ext:Store>
                        </Store>
                        <ColumnModel>
                            <Columns>
                                <ext:Column runat="server" DataIndex="id" Text="编号"></ext:Column>
                                <ext:Column runat="server" DataIndex="casename" Text="案例" Flex="1"></ext:Column>
                                <ext:Column runat="server" DataIndex="pic" Text="缩略图" ></ext:Column>
                                <ext:Column runat="server" DataIndex="url" Text="网址"></ext:Column>
                                <ext:Column runat="server" DataIndex="addtime" Text="时间" Format="yyyy-MM-dd"></ext:Column>
                            </Columns>
                        </ColumnModel>
                    </ext:GridPanel>
    Click image for larger version. 

Name:	QQ截图20140214213331.png 
Views:	8 
Size:	29.3 KB 
ID:	7594Click image for larger version. 

Name:	QQ截图20140214213433.png 
Views:	6 
Size:	11.5 KB 
ID:	7595
    Last edited by Daniil; Feb 17, 2014 at 3:38 AM. Reason: [CLOSED]
  2. #2
    You have to use DateColumn instead Column (Column has no Format property)
  3. #3
    Quote Originally Posted by Vladimir View Post
    You have to use DateColumn instead Column (Column has no Format property)
    thank you , work perfect!

Similar Threads

  1. Replies: 2
    Last Post: Nov 12, 2013, 1:40 PM
  2. [CLOSED] DateTime format renderer in GridPanel
    By speedstepmem4 in forum 2.x Legacy Premium Help
    Replies: 7
    Last Post: Oct 25, 2013, 1:56 PM
  3. [CLOSED] datetime format in ModelField?
    By hdsoso in forum 2.x Legacy Premium Help
    Replies: 3
    Last Post: Oct 18, 2013, 12:20 PM
  4. [CLOSED] DateTime format on Grid problem
    By caha76 in forum 1.x Legacy Premium Help
    Replies: 1
    Last Post: Mar 18, 2011, 7:47 PM
  5. Replies: 2
    Last Post: Aug 31, 2009, 6:03 PM

Posting Permissions