Formatting date and time

SouthendSupporter · July 28th, 2009, 10:40 AM

Hi,
I am using the following in gridviews:

Code:

<Columns>
                                    
<asp:BoundField DataField="EventDate"
HeaderText="Date" 
ItemStyle-Width="120"  
SortExpression="EventDate" 
DataFormatString="{0:d MMMM yy}"
<ItemStyle HorizontalAlign="Left" />
</asp:BoundField>
                    
<asp:BoundField DataField="Time" HeaderText="Time"   
ItemStyle-Width="75"
 SortExpression="Time"
DataFormatString="{0:h:mm tt}" >
 <ItemStyle HorizontalAlign="center" />
 </asp:BoundField>
........... other columns
</columns>

The [EventDate] field formats correctly as for example 12 July 09
BUT..the [Time] field seems to ignore the DataFormatString appearing as 15:09:34

EventDate is datatype Date
Time is datatype Time

So what am I missing?

Imar · July 28th, 2009, 10:56 AM

Hi there,

Is this related to the book Beginning ASP.NET in C# and VB.NET? If so, can you specify a page number or chapter?

If it isn't related, can you post generic ASP.NET questions like this one in one of the generic ASP.NET categories: http://p2p.wrox.com/asp-net-3-5-436/ Makes it easier for me and others to manage relevant threads.

That said, try setting the HtmlEncode property of the BoundField to False....

Imar

SouthendSupporter · July 28th, 2009, 06:06 PM

Hi Imar
I was using information from Chapter 12 p408 to guide me in displaying a date correctly.

I opted to use custom formats as that is what I found on various web sites.

As I say, the date works just fine, but the time seems to refuse to format.
Setting the HtmlEncode and/or the HtmlEncodeFormatstring propertyto False makes no difference.

So I guess there is something wrong with my Time Datatype in the database. I've changed it to DateTime and all works so I'll be happy with that!
(Don't like being beaten tho

)