How to specify data parameter in my rdf for Oracle R12.2
Good day ,
I have developed a report that extracts receipts between a FROM and a TO date. The line of code in my where statement is as follows:
WHERE TO_CHAR(RECEIPT_DATE, 'DD-MON-YYYY') >= trunc(FND_CONC_DATE.string_to_date(:p_from_date))
and TO_CHAR(RECEIPT_DATE, 'DD-MON-YYYY') <= trunc(FND_CONC_DATE.string_to_date(:p_to_date))
When I run the code in TOAD it returns data correctly. When I run the code out of the rdf it returns the data correctly. I enter the parameter values as 01-DEC-2006 to 31-DEC-2006 as an example.
The concurrent program parameters for date has been defined using FND_DATE_STANDARD