Oracle Date Parameter in TI doesn't work

[bunchukokoy]

Hi,

I'm using oracle 10g and TM1 10.1.1.

Made a string param, but it doesn't return any row when I click preview button.

SELECT INVOICE_DT, CUST_CODE, PLANT_CODE, PRDTP, REV_INVOICE
FROM ODS_TABLE
WHERE INVOICE_DT = '%pStartDate%'

When I replace '%pStartDate%' with '24-SEP-2012', it works fine.

INVOICE_DT field is Date type. and the parameter value I have is '24-SEP-2012' because '09/24/2012' doesn't work. There are also existing records.

Is there something wrong in my syntax?

Thanks very much

Bunch

[bunchukokoy]

Eow. Stupid mistake.
Should be '?pStartDate?' instead of '%pStartDate%'

Thanks.