Sep 11, 2015, 6:03 AM
rendering date difference in a gridpanel column
Hello, I've some problem rendering date difference in a gridpanel column.
I'm trying to get difference (in days) between a date in the same row and today's date. But the return value is always "NaN".
Is there something wrong with the handler?
Here's my code,
I'm trying to get difference (in days) between a date in the same row and today's date. But the return value is always "NaN".
Is there something wrong with the handler?
Here's my code,
<body style="background-color: #DFE8F6">
<form id="form1" runat="server">
<ext:ResourceManager ID="ResourceManager1" runat="server" />
<ext:Hidden ID="HiddenField1" name ="HiddenField1" runat="server"></ext:Hidden>
<ext:Hidden ID="HiddenField2" name ="HiddenField2" runat="server"></ext:Hidden>
<ext:Hidden ID="HiddenField3" name ="HiddenField3" runat="server"></ext:Hidden>
<div>
<br />
<table width="98%" align="center">
<tr>
<td>
<ext:TabPanel ID="TabPanel1" runat="server" DeferredRender="false" Layout="ColumnLayout" Border="false" BodyStyle="background-color: #DFE8F6" Frame="true" Autoscroll="True" Anchor="100% 100%">
<items>
<ext:Panel ID="Panel1" runat="server" Title="New">
<items>
<ext:GridPanel ID="GridPanel4" runat="server" Title="" overflow="auto" fitToFrame="true" Anchor="100% 100%">
<store>
<ext:Store runat="server" ID="strNew">
<Model>
<ext:Model runat="server" ID="Model3">
<Fields>
<ext:ModelField Name="ProjectID" Type="String" />
<ext:ModelField Name="CreateDate" Type="String"/>
</Fields>
</ext:Model>
</Model>
</ext:Store>
</store>
<ColumnModel>
<Columns>
<ext:Column ID="Column1" runat="server" Text="ProjectID" Width="80" DataIndex="ProjectID" />
<ext:Column ID="Column7" runat="server" Text="Aging" Width="80">
<Renderer handler="var today = Date.parse(Date.now()); var createdt = Date.parse(record.data.CreateDate); var diffDays = Math.round(parseInt(today-createdt) / (86400000)); return diffDays;" />
</ext:Column>
<ext:Column ID="Column13" runat="server" Text="Create Date" Width="100" DataIndex="CreateDate" />
</Columns>
</ColumnModel>
</ext:GridPanel>
</items>
</ext:Panel>
</items>
</ext:TabPanel>
</td>
</tr>
</table>
</div>
</form>
</body>
