> For ODBC queries, you should be using ODBC formatted dates. Once again,
you
> need to start with a valid date/time.
>
> <cfset today = "11-04-2000"> <!--- this format is OK with CF --->
>
> <cfquery name="myquery" datasource="#mydsn#">
> SELECT *
> FROM mytable
> WHERE thedate = #CreateODBCDate(DateAdd("d", 7, today))#
> </cfquery>
*Great*, thanks Jim. I thought I should have been using CreateODBC but
couldn't remember the correct syntax. It's all working really smooth. One
final question - I'm sending out emails saying "Your ad will expire on
#CreateODBCDate(DateAdd("d", 28, today))#" - what would be the syntax so
that it formats the date to "Wednesday 28th November"?
Thanks,
Will
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]