Try these.
<Cfset Mydate="#varMM#/#varDD#/VarYYYY#'>
you can do sql selects without formating the aboue.
etc
select * from yourTable where DataField='#Mydate#'
or
if you just need the current date
<cfset Mydate=#DateFormat(now(), "MM/DD/YY")#>
----- Original Message -----
From: "Michael Gagnon" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, October 21, 2000 10:59 AM
Subject: Combining day/month/year variables into 1 ODBC format variable
> Hi!
>
> I am looking for a way to combine 3 variables
> (date, month, year) into 1 variable
> and convert it into an ODBC format.
>
> Does anyone have a trick up their
> sleeves for this?
>
> Thanks!
>
>
> -------------------------------------------------------------------------
-----------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
