Time Format

[Ed Richter]

Am wondering if there's a way to not have a time field print out including seconds as shown
4:30:00 PM My raw data in the Access database is set to medium time format and is shown in the table as follows: 4:30 PM

The cell is formatted as follows:

<td width="169"><font face="arial,helv" size="3"><% = rsObj("G_Time") %></td>

Do I need to add some type of formatting into the html page to get rid of the seconds being displayed? I thought changing format in table would have been enough, but I guess not??

Thanks!

 

[Thomas A. Rowe]

Try:

<%
Gtime = rsObj("G_Time")
%>

<td width="169"><font face="arial,helv" size="3"><%=FormatDateTime(Gtime,vbLongTime)%></td>
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================


Am wondering if there's a way to not have a time field print out including seconds as shown
4:30:00 PM My raw data in the Access database is set to medium time format and is shown in the
table as follows: 4:30 PM

The cell is formatted as follows:

<td width="169"><font face="arial,helv" size="3"><% = rsObj("G_Time") %></td>

Do I need to add some type of formatting into the html page to get rid of the seconds being
displayed? I thought changing format in table would have been enough, but I guess not??

Thanks!