Substracting Two Dates in DataGrid

When you need to subtract two days in data grid use the following:

<asp:TemplateColumn HeaderText="Duration">
       <ItemTemplate>
           <DevControls:Label runat="server" ID="lbl" Text='<%# (((DateTime)Eval("EndDateTime"))-((DateTime)Eval("StartDateTime"))).TotalDays + "Day/Days" %>' />
       </ItemTemplate>
</asp:TemplateColumn>
<asp:BoundColumn HeaderText="StartDate" DataField="StartDateTime" DataFormatString="{0:ddd, dd/MM/yyyy}" />
<asp:BoundColumn HeaderText="FinishDate" DataField="EndDateTime" DataFormatString="{0:ddd,  dd/MM/yyyy}" />
Advertisements