Thanks man. Fixed it.
On the same website, I have this problem where the time isn't being displayed from an MSSQL datetime field via the following code:
<%IF FormatDateTime((rsEVENT.Fields.Item("tmsastartdate").Value), vbShortTime) >= "00:00" Then %><%ELSE%>
<%IF FormatDateTime((rsEVENT.Fields.Item("tmsastartdate").Value), vbShortTime) >= "11:59" Then %>
<h2><%= FormatDateTime((rsEVENT.Fields.Item("tmsastartdate").Value), vbShortTime) %> pm</h2>
<%ELSE%>
<h2><%= FormatDateTime((rsEVENT.Fields.Item("tmsastartdate").Value), vbShortTime) %> am</h2>
<%End IF%>
<%End IF%>
Here's an event that has this problem:
http://www.tmsa.org.uk/scottish-music-event.asp?e=2085&b=1
The "tmsastartdate" for this event is stored in the datetime field as:
03/12/2014 21:00:00
I appreciate that's above and beyond but I know you're good at spotting things like this. Appreciate it.
NJ
EDIT: Hmm, looking at the code I'm not sure what I was trying to achieve apart from displaying AM or PM. Changed it to this:
<%IF FormatDateTime((rsEVENT.Fields.Item("tmsastartdate").Value), vbShortTime) >= "11:59" Then %>
<h2><%= FormatDateTime((rsEVENT.Fields.Item("tmsastartdate").Value), vbShortTime) %> pm</h2>
<%ELSE%>
<h2><%= FormatDateTime((rsEVENT.Fields.Item("tmsastartdate").Value), vbShortTime) %> am</h2>
<%End IF%>
...and it seems to have resolved it.
