SQL Querys and dates and or Query setup

I am trying to query the requests database but no matter what I do I can not get it to give me the following results :

I want all requests that were open on DATE X, that were created before DATE X for CUSTOMER Y. I have tried using the report builder and also the query builder. Neither provides the correct results. Using the query builder btw always gives the following error : java.lang.Exception: Syntax error : function LONGTODATE not closed properly!

This is using the query copied straight out of the report generated by your software.

The following is a test query i tried to create by hand :

SELECT ti.FIRST_NAME "Technician",ti.FIRST_NAME "Technician",wo.CREATEDTIME "Created Time",wo.COMPLETEDTIME "Completed Time" FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON

wot.WORKORDERID=wo.WORKORDERID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID WHERE

(((wo.CREATEDTIME >= datetolong('2004-04-26') AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL))) AND ((wo.CREATEDTIME <= 1238569199000) AND (((wo.CREATEDTIME != 0) AND

(wo.CREATEDTIME IS NOT NULL)) AND (wo.CREATEDTIME != -1)))) AND (wo.COMPLETEDTIME > 1238569199000)) AND wot.THD_WOID=wot.WORKORDERID ORDER BY 1, 3