Formatting Time

[Scott]

I have a datetime field that looks like 7/24/2004 8:45:00 AM

I just want to display 8:45 AM

<%= FormatDateTime(Now, 3 )%> returns: 8:45:00 AM

Any idea how to get rid of seconds?

 

[SPD]

Here's one option:

<%
Function DisplayTime(thisTime)
Dim strTime
strTime = FormatDateTime(thisTime, 3)
DisplayTime = Left(strTime, InStrRev(strTime, ":")-1) & Right(strTime, 3)
End Function


Response.Write DisplayTime("7/24/2004 8:45:00 AM") %>

 

[Ken Cox [Microsoft MVP]]

Try this?

Format(Now, "hh:mm tt")

 

[SPD]

Doesn't do anything for me except throw an undefined variable error.

 

[Scott]

thanks, i needed help using strings. nesting them gets confusiing sometimes.