Problem with adding parameter in a command

[crystalnewbie]

CR9 / Oracle8

I'm trying to add the sql below in the CR repository. I need to include a {?StartDate} and {?EndDate} parameter in the sql. I think I got the syntax correct but am getting the following error message: "Failed to open a rowset. ORA-00936: Missing Expression"

If i take out the line on the WHERE clause that has the parameter, the command gets added to the repository. So I'm hoping its just a syntax error.

Thanks

---------------------------

SELECT DISTINCT
"PS_JOB"."ACTION", "PS_JOB"."AL_EMPL_STATUS", "PS_JOB"."EFFDT", "PS_JOB"."EMPLID", "PS_JOB"."EMPL_STATUS", "PS_JOB"."FLSA_STATUS", "PS_JOB"."JOBCODE", "PS_AL_CHK_DATA"."CHECK_DT", "PS_JOBCODE_TBL"."DESCR", "PS_PERSONAL_DATA"."NAME"
FROM
"PS_JOB", "PS_AL_CHK_DATA", "PS_JOBCODE_TBL", "PS_PERSONAL_DATA"
WHERE
(((("PS_JOB"."EFFSEQ"= (
SELECT MAX("INNERALIAS"."EFFSEQ")
FROM "PS_JOB" INNERALIAS
WHERE "INNERALIAS"."EMPLID" = "PS_JOB"."EMPLID"
AND "INNERALIAS"."EFFDT" = "PS_JOB"."EFFDT")
AND
"PS_JOB"."EFFDT" = (
SELECT MAX("INNERALIAS"."EFFDT")
FROM "PS_JOB" INNERALIAS
WHERE "INNERALIAS"."EMPLID" = "PS_JOB"."EMPLID"
AND "INNERALIAS"."EFFDT" <= SYSDATE))) AND
(("PS_JOBCODE_TBL"."EFFDT" = (
SELECT MAX("INNERALIAS"."EFFDT")
FROM "PS_JOBCODE_TBL" INNERALIAS
WHERE "INNERALIAS"."JOBCODE" = "PS_JOBCODE_TBL"."JOBCODE"
AND "INNERALIAS"."EFFDT" <= SYSDATE))) AND

---PUT PARMS HERE----
---Having problems here---
("PS_AL_CHK_DATA"."CHECK_DT" BETWEEN <<'{?StartDate}', "TO_DATE('"yyyy"-"mm"-"dd"', 'YYYY-MM-DD')">> AND <<'{?StartDate}', "TO_DATE('"yyyy"-"mm"-"dd"', 'YYYY-MM-DD')">>) AND
------------------

("PS_AL_CHK_DATA"."AL_NET_PAY" > 0) AND
("PS_AL_CHK_DATA"."PAYROLL_NBR" = '1')))
AND
("PS_JOB"."EMPLID" = "PS_PERSONAL_DATA"."EMPLID" ) AND ("PS_JOB"."EMPLID" = "PS_AL_CHK_DATA"."EMPLID"(+) ) AND ("PS_JOB"."JOBCODE" = "PS_JOBCODE_TBL"."JOBCODE" )
GROUP BY
"PS_JOB"."ACTION", "PS_JOB"."AL_EMPL_STATUS", "PS_JOB"."EFFDT", "PS_JOB"."EMPLID", "PS_JOB"."EMPL_STATUS", "PS_JOB"."FLSA_STATUS", "PS_JOB"."JOBCODE", "PS_AL_CHK_DATA"."AL_NET_PAY", "PS_AL_CHK_DATA"."CHECK_DT", "PS_JOBCODE_TBL"."DESCR", "PS_PERSONAL_DATA"."NAME"
ORDER BY
"PS_JOB"."ACTION", "PS_PERSONAL_DATA"."NAME

 

[crystalnewbie]

Never mind. It was a syntax error. Taking out the '<<' & '>>' in the query did the trick.