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 18.104.22.168.0 version and using the xtp format
Any help will be appreciated and I have deadlines so prompt answers will be great for me
Have you reviewed
4. Enter the Date Format String. The format must be a Java date format (for example, MM-dd-yyyy).
You set the format of the source database
How do i do it?
if i am understanding your suggestion correctly then in this case ur blah_date is the date coming from column in the db table its format is (7/18/2013 00:00:00 ) in my case and P_start_Date and P_end_date are the parameters which store the date in this format (2013-09-16T08:00:00.000+01:00) coming from BIP depending on what the user selects
I dont think it will work Can you formulate the query for me
the name of the column from db is review_date
and 2 parameters start_review_date and end_review_date coming from the BIP user selects the values and it gets stored in these 2 params and compare it with review_date column....Gimme the query...?