Date Issue IN RDF

For solve the Date issue in RDF

option 1

1) In RDF Date parameter
datatype : Character
size  : 40

In SQL Query condition like below

Where TRUNC (gl_date)= fnd_date.canonical_to_date (:p_as_of_date)

In Concurrrent program paramater datatype is
Values Set :-  FND_STANDARD_DATE
Token :- p_as_of_date

option 2

1) In RDF Date parameter
datatype : Date
size  : 40
Input mask :  YYYY/MM/DD HH24:MI:SS

In SQL Query condition like below

where CH.CHECK_DATE BETWEEN NVL (:P_START_DATE, CH.CHECK_DATE)

and in Concurrrent program paramater datatype is
Values Set :-  FND_STANDARD_DATE
Token :- P_START_DATE