Skip to main content
Inspiring
January 21, 2008
Question

Time Format In DW 8 - Not Working

  • January 21, 2008
  • 2 replies
  • 295 views
I'm getting this error in a dropdown menu containing times. 07:00 am 07:15
am etc.........
I have the database field as Date/Time (Access 2003)
My code for the dropdown menu is below.
Any idea what the problem is???
Thanks
Andy

I'm getting this error:

-----------------------------------
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'DoDateTime'

-----------------------------------
<select name="LeavingDate" class="maintxt" id="LeavingDate">
<%
While (NOT RSTime.EOF)
%>
<option value="<%=(RSTime.Fields.Item("ID").Value)%>"><%=
DoDateTime((RSTime.Fields.Item("time").Value), 3, 1033) %></option>
<%
RSTime.MoveNext()
Wend
If (RSTime.CursorType > 0) Then
RSTime.MoveFirst
Else
RSTime.Requery
End If
%>
</select>



This topic has been closed for replies.

2 replies

Inspiring
January 22, 2008
Hi -
No, i'm using a table containing the times - These times are 'Date/Time'
Data Type with a format of 'Lomg Time'
I have tried many combinations, but nothing seems to work.
The times are displayed in a dropdown menu and display as 7:00:00 AM
Where does the AM come from?

All im trying to do is populate a dropdown menu with a list of times. User
selects time and this is then inserted in to the Access Database.
The formatting is driving me nuts :-|

Thanks in advance
Andy

"jsteinmann" <webforumsuser@macromedia.com> wrote in message
news:fn2pmp$svp$1@forums.macromedia.com...
> are you using now() to populate the database tables?


January 21, 2008
are you using now() to populate the database tables?