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,
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>
Thanks before.