#CreateODBCDate(createDate(year(now()),month(now()),day(now())))#
----- Original Message -----
From: "Joseph Eugene" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, October 22, 2000 12:25 AM
Subject: Re: Combining day/month/year variables into 1 ODBC format variable
> 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]
>
------------------------------------------------------------------------------------------------
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]
