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 11.1.1.7.0 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

Legend

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