Formatting Dates from Database

The following takes from the database a list of date and displays them in a table on an asp page


...........

<td align = center><font color = "black" size = 2><b><%=trim(rs.Fields (2))%></b></font></td>



..............................

however it displayes it in this format: May 12 2003 12:00AM

Is there a simple way of getting it in the mm/dd/yyyy format without reading it in as a string first? I mean can I just change something in the above code to do this?


I was trying the following but couldnt get it working, could you tell me how to use it in this context?


<%=Format(trim(rs.Fields (2)), FormatString)%>

This is the error I'm getting

thanks

R&D the FormatDateTime() function

Hope this helps!
Sincerely

Vlince