Adding Date Parameters in RDF Report IN EBS

 Adding Date Parameters in RDF Report IN EBS 

Step1 : In Query use the date below format for Date Parameters :

                AND TRUNC (mmt.TRANSACTION_DATE) 

                BETWEEN NVL (:P_DATE_FROM,TRUNC(mmt.TRANSACTION_DATE))

                AND NVL (:P_DATE_TO,TRUNC (mmt.TRANSACTION_DATE))

Step 2: Set the Input mask, Datatype and width (SIZE)

Go to parameter properties→set datatype: Date→Width: 40→Input Mask: YYYY/MM/DD HH24:MI:SS 

            Set these above properties from both P_DATE_FROM & P_DATE_TO parameters.

Step 3: In concurrent Program Use FND_STANDARD_DATE Value Set for both the From Date & TO Date Parameters.