This discussion is archived
1 2 Previous Next 24 Replies Latest reply: Sep 26, 2013 7:44 AM by 348fad86-ffed-4c6d-9fa3-6964b2ec779c RSS

Date Range in BI Publisher 11g

348fad86-ffed-4c6d-9fa3-6964b2ec779c Newbie
Currently Being Moderated

The user wants to select the data from the table in such a way that he specifies the start and end date how do I do the comparison and filter the data of my report accordingly


Date Format of the column from the database: 7/18/2013 00:00:00


Date Format of the calender parameter of OBIEE BIP:  2013-09-16T08:00:00.000+01:00


How do i compare these dates now


I am really stuck in this


I am using Oracle Business Intelligence version and using the xtp format

Any help will be appreciated and I have deadlines so prompt answers will be great for me

1 2 Previous Next


  • Correct Answers - 10 points
  • Helpful Answers - 5 points