You will have to convert the ODBC DateTime to another format in the template
using the DateFormat function of CF.
<CFOUTPUT>
#DateFormat("#date#", "mm/dd/yyyy")#
</CFOUTPUT>
That should work...
----- Original Message -----
From: "Neil H." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 4:42 PM
Subject: SQL date.
> I would like SQL server to return the date in the format of mm/dd/yyyy
> without the time. Is this possible? Actually I know it possible the
> problem is how :)
>
>
> Thanks,
>
> Neil
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists