[cfaussie] RE: New look up date by years old with a 2 year spread < 2 > 2

[cliftosg]

Title: Message

you have probably solved this by now, but here goes anyway:   <cfset Form.age = 5> <!--- set age diff ---> <cfset Older = Form.age + 2> <cfset Younger = Form.age - 2>   <!--- create the dates ---> <cfset Olderthan = dateformat(DateAdd("yyyy", -Older, Now()),'yyyy-mm-dd')> <cfset Youngerthan = dateformat(DateAdd("yyyy",-Younger,Now()),'yyyy-mm-dd')> <!--- get all records where member was born between #Olderthan# and #Youngerthan# ---> <cfquery name="getRecord" datasource="interact">  SELECT  Talent.talentID ,    Talent.Name ,   Talent.Gender ,   Talent.DOB ,   Talent.Hair ,   Talent.Eye ,   Talent.Height ,   Talent.Clothessize ,   Talent.shoesize ,   Talent.hobbies ,   Talent.BIO ,   Talent.Compcard ,   Talent.ID  FROM   Talent  where (Talent.DOB <= {d '#Olderthan#'} and Talent.DOB >= {d '#Youngerthan#'}) </cfquery>   take note of the positioning of the squiggly brackets "{ }" as opposed to the normal brackets "( )"   steve   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, 19 March 2003 10:09 PM To: CFAussie Mailing List Subject: [cfaussie] New look up date by years old with a 2 year spread < 2 > 2 Hi thank you for all who helped yesterday i am still stuck so i decided to clean up and simplfy the code to help debug   here we go again:     <cfset Form.age =5> <!--- set age diff ---> <cfset Older = Form.age + 2> <cfset Younger = Form.age - 2>   <!--- create the dates ---> <cfoutput> <cfset Olderthan = #CreateODBCDateTime(DateAdd("yyyy", -Older, Now()))#><br> <cfset Youngerthan = #CreateODBCDateTime(DateAdd("yyyy",-Younger,Now()))#> get all records where member was born between #Olderthan# and #Youngerthan# </cfoutput>   <cfquery name="getRecord" datasource="interact">  <cfoutput><pre>  SELECT  Talent.talentID ,    Talent.Name ,   Talent.Gender ,   Talent.DOB ,   Talent.Hair ,   Talent.Eye ,   Talent.Height ,   Talent.Clothessize ,   Talent.shoesize ,   Talent.hobbies ,   Talent.BIO ,   Talent.Compcard ,   Talent.ID  FROM   Talent  where Talent.DOB between ('#Olderthan#') and ('#Youngerthan#') </pre></cfoutput> </cfquery>     get all records where member was born between {ts '1996-03-19 22:06:56'} and {ts '2000-03-19 22:06:56'}   The ERROR MESSAGE