time format in database results

[howard]

I need help with my database results page. The time
format reads 1/1/1900 6:00:00 PM, when all I want is 6:00
PM. Why does this happen and how do i fix it?

 

[Kathleen Anderson \(MVP - FrontPage\)]

Where are you getting the time from? Is it a field in your database? What is
the name and datatype of the field?



--

~ Kathleen Anderson
Microsoft FrontPage MVP
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

 

[grw]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/ht
ml/vsfctformatdatetime.asp

Use the format :
<%=FormatDateTime(FP_Field(fp_rs,"YourValue"), x )%>

Where "x" equals a value 0 - 4 (from the URL above)
2 or 4 may suit your needs

Youll need to remove the 'gray' code around the original red code
<%=FP_Field(fp_rs,"YourValue")%> to make it stick

 

[Howard]

It's an Access table, where the date format is set to
display 6:00 PM, etc., but when Front Page displays it in
the database results, it shows 1/1/1900 6:00:00 PM.