|
|
Hi again,
Just to say that I've tried to cheat it a little, with the following:
<%IF FormatDateTime((rsEvent.Fields.Item("eventdatetime").Value),
vbShortTime) > "11:59" Then %>
<%= FormatDateTime((rsEvent.Fields.Item("eventdatetime").Value),
vbShortTime) %> PM
<%ELSE%>
<%= FormatDateTime((rsEvent.Fields.Item("eventdatetime").Value),
vbShortTime) %> AM
<%End IF%>
...seems to have done the trick! What a "carry on" though! :o)
Nath.
"Dooza" <doozadooza@xxxxxxxxx> wrote in message
news:g6uh6j$5vb$3@xxxxxxxxxxxxxxxxxxxxxxxx
> tradmusic.com wrote:
>> Is there any way to format the time section of a smalldatetime field to:
>>
>> HH:mm AM/PM
>>
>> Seems there's every format, except that one! Reckon I'm jinxed.
>>
>> Nath.
>
> Try this: http://www.codetoad.com/asp/format_date_time.asp
>
> Steve
|
|