data fomat for "Time"??????

[sweetp]

I have a field I'm trying to display (from a recordset) that shows "start time". How do I format the field to show time like (11:32 am)?? If I choose Format under bindings I only get choices to format date. If I choose None, then it shows up as: 1899-12-30 11:32:00.0 I'm using MX, JSP and Access.

Help please!

 

[YNOTU]

[tt]faq333-3194

 

[sweetp]

Thanks, but the problem now is that I don't know enough yet to apply the code in the FAQ to my page. The field name that I want to format is StartTime. How do I apply the:

Dim curDate
curDate = Now()
Response.Write &quot;vbLongTime - & FormatDateTime(curDate,vbLongTime) & &quot;<BR>&quot;

to my page? Do I substitute StartTime somewhere? Also, where do I put the (I assume it goes between a set of <% %>.

Thanks again for any help for this newbie!

 

[TruthInSatire]

that wont work if you're using jsp. that is ASP code. Ask the JSP forum for best results.

http://thereptilian.com/