[cfaussie] Re: why wont this date function work?

[Phil Evans]

Try the following:

 

1. get a toupee

 

2. untested - but should work

 

<cfset start_date ='15/04/1997'>

<cfset end_date = '15/04/2004'>

 

<cfquery name="testben" datasource="mydsn">
 SELECT *
 FROM bentester 
WHERE bentester.EndDate

    Between #createODBCDate(Start_Date)#

          And #createODBCDate(End_Date)#
</cfquery>

 

HTH

 

Phil.

 

----- Original Message -----

From: "Jamie Lawrence Jenner" <[EMAIL PROTECTED]>

To: "CFAussie Mailing List" <[EMAIL PROTECTED]>

Sent: Saturday, May 08, 2004 1:36 AM

Subject: [cfaussie] why wont this date function work?

> Hi
>
> hi
>
> i have no hair! why wont this work!
>
> The date in the db is 18/05/2001 and im using access.
>
> <cfset start_date =DateFormat(createODBCDate(15/04/1997),'dd/mm/yyyy')>
> <cfset end_date = DateFormat(createODBCDate(15/04/2004),'dd/mm/yyyy')>
>
> <cfquery name="testben" datasource="mydsn
> SELECT *
> FROM bentester
> WHERE Format(bentester.EndDate,'dd/mm/yyyy') Between #Start_Date# And
> #End_Date#
> </cfquery>
>
> <cfoutput>
> #bentester.enddate#
> </foutput>
>
> ---
> You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to [EMAIL PROTECTED]
>
> MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
> http://www.mxdu.com/ + 24-25 February, 2004
> ---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004