Choise date BETWEEN 2 dates from SQL table

[radziowi]

Hello!
I have got problem with date in SQL query. I would like choise date bettwen 2 dates for example SQL query

select * from news WHERE data BETWEEN 24-07-2007 AND  06-08-2007

In SQL working but when i use Cold Fusion my query is still wrong

<cfset today = Now()>
<cfoutput>#DateFormat(today, "dd-mmm-yyyy")#</cfoutput>
<cfquery name="News" datasource="#DSNname#">
SELECT * FROM News WHERE Date = #DateFormat(today, "dd-mmm-yyyy")#</cfquery>

I try a lot of way change WHERE Date = #DateFormat(today, "dd-mmm-yyyy")# but nothing working. Maybe somebody can help me??

[improvcornartist]

Have you tried using #DateFormat(today, "yyyy-mm-dd")#? If that doesn't work, you might try something like

<CFSET new_date =#CREATEODBCDATETIME("7/24/2007")#>

and use it in the query instead of DateFormat.

Also, the problem may only be that you are referencing the table column by Date, which might be reserved and thus could cause errors.

[radziowi]

<CFSET new_date =#CREATEODBCDATETIME("7/24/2007")#>

Also, the problem may only be that you are referencing the table column by Date, which might be reserved and thus could cause errors.

Thank a lots made:) It's working. I must use ]

<CFSET new_date =#CREATEODBCDATETIME("7/24/2007")#>

and later its ok:) I find later something interesting about format data in Cold Fusion
http://www.school-for-champions.com/...sion/dates.htm
but your replay help me. Thanks again.