display time with AM and PM? vbShortTime? No secs! (story of my...)

[Nathon Jones]

Hi,

I have a time field in my Access DB. I'm using VBScript/ASP.

How do I get the time to display as:
17:00 PM rather than 17:00:00 PM?

This is what I'm using to get 17:00:00 PM at the moment:

<%= DoDateTime((rsEventInfo.Fields.Item("starttime").V alue), 3, 1033) %>

What do I need to change to get the desired result?

Thanks
Nath.

[Mintyman]

You could write some VB to only display the left most 5 characters


"Nathon Jones" <nathonjonesNOT@kirkmoor.com> wrote in message
news:d0jvl2$igu$1@forums.macromedia.com...

> Hi,
>
> I have a time field in my Access DB. I'm using VBScript/ASP.
>
> How do I get the time to display as:
> 17:00 PM rather than 17:00:00 PM?
>
> This is what I'm using to get 17:00:00 PM at the moment:
>
> <%= DoDateTime((rsEventInfo.Fields.Item("starttime").V alue), 3, 1033) %>
>
> What do I need to change to get the desired result?
>
> Thanks
> Nath.
>
>