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

    Date Range in BI Publisher 11g

    348fad86-ffed-4c6d-9fa3-6964b2ec779c

      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