Date problem with access

[8ginga8]

Can someone please help i have this query below that when it is pasted into access and the variables are replaced with dates the query excutes fine, but as soon as I do the same query in CF it doesn't work. No error

<cfquery datasource="#datasource#" name="get_done">
SELECT  *
FROM QUARTER LEFT JOIN SURVEY ON QUARTER.qrt_id = SURVEY.qrt_id
WHERE QUARTER.qrt_stamp >= #createodbcdatetime(SESSION.bioalliance.user_create)# AND (Exists (select * from SURVEY
  where SURVEY.qrt_id = QUARTER.qrt_id and user_id = #SESSION.bioalliance.user_ID#)=False) AND QUARTER.qrt_stamp2 <= #createodbcdatetime(today)#
 </cfquery>

 

[8ginga8]

I fixed it thank anyways