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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s