http://livedocs.adobe.com/ Macromedia LiveDocs - online documentation with user feedback. Copyright 2009, Macromedia, Inc. 2009-11-26T02:40:51 en-us http://livedocs.adobe.com/coldfusion/7/htmldocs/00000483.htm#65908 Consider this code:<br /><br /><cfquery datasource="#application.websitedb#" name="datetest"><br /> SELECT GETDATE() AS MyDate -- returns current time of the SQL server<br /></cfquery><br /><br /><cfoutput><br />Isdate?: #IsDate(datetest.MyDate)#<br><br />#GetHTTPTimeString(datetest.MyDate)#<br /><cfoutput><br /><br />In this case GetHTTPTimeString fails silently, even though the parameter supplied is a correct date_time object. Surround the date with CreateODBCDateTime function and it works as expected.<br />/m MU 0 0 2007-04-26T08:23:42