<font face='Arial'>I am trying to compare times from two Access database tables. When I run a test from Dreamweaver's recordset dialog box, it works fine.

<img src="www.nsmicrowave.com/images/ScreenShot1.jpg" border=0>

When I run it on the server, I get the following error.

<img src="www.nsmicrowave.com/images/Error-Message.jpg" border=0>

How do I format my date in the recordset dialog box to show only the time so this will display on the server correctly?

Thanks for any help you can give me.</font id='Arial'>