BI publisher render data by comparing dates
Hi,
I am trying to create a BI publisher report using an rtf , in which user is provided an option to select start date and end date in which the data is filtered by comparing dates.
I am providing start date and end date using the calendar and i have the following condition in place,
SampleDate>= StartDate AND SampleDate<= EndDate in my RTF.
The SampleDate from siebel db has the date format MM/DD/YYYY.
The logic is in place, but its not working, i am not sure if the format of calendar date and sample date are the same?