Format Time Question

mdr2273 · Oct 31, 2006

How would I format an Access time field to display as 8:00 PM?

DotNetGnat · Oct 31, 2006

Code:

<%
response.write formatdatetime(now(),3)
%>

-DNG

mdr2273 · Oct 31, 2006

This makes the result show up as 8:00:00 PM. Is it possible to get rid of the seconds?

DotNetGnat · Oct 31, 2006

try this:

Code:

<%
dim mydate
mydate= split(formatdatetime(now(),3)," ")
response.write Mid(mydate(0),1,instrrev(mydate(0),":")-1) &" "& mydate(1)

%>

-DNG

mdr2273 · Oct 31, 2006

Works like a charm, thanks!

DotNetGnat · Oct 31, 2006

no problem...glad to assist...

-DNG

ChrisHirst · Oct 31, 2006

or of course

Code:

formatdatetime(now(),[b]4[/b])

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.