on 09-18-2014 5:15 PM
Hi Experts,
I am facing an issue with Date Interval in BO report. We are using BICS connection and the date interval format we are receiving in BO is
dd-mm-yyyy hh:mm:ss a : dd-mm-yyyy hh:mm:ss a
eg: 01-01-2013 12:05:06 AM : 12-12-2013 10:06:05 PM
I would like the display format for the date prompt in BO to be 01-01-2013 - 12-12-2013
Please give your valuable solutions for this issue.
Regards,
G.
Thank you for ur reply,,
Actually the problem is the date prompt coming from Bex query.I am using BICS connection.
Date format coming like this
Ex: 01-01-2013 12:05:06 AM : 12-12-2013 10:06:05 PM
Now i want format 01-01-2013 - 12-12-2013
Regards,
G
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
You can request your BW team to change the data format in the bex Q according to BO,
Coz your using BICS connection and there is no universe, so request your BW
team to change the format.
Coz some calculations,filtering, formats which are done at universe or report level could be pushed down to database level (without the need to actually
modify the database).
This has advantages, final users have less work to do.
Thank you for ur reply....
I have tried this formula, Substr(Trim([Interval]);1;10)+":"+Substr(Trim([Interval]);26;10)
still am facing issue.
Ex: Date like 9 digits 1/02/2014 1 - 2/04/2014 1 its showing like this
Date like 10 digits is working fine 12/31/2013 - 12/31/2012
Any one give me suggestions how to achive this..
Thank you Advance
Regards,
G
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bhargav ,
Assume userresponse is "Select Date" .use below code.
From date
=FormatDate(ToDate(Substr(UserResponse("Select Date");1;Pos(UserResponse("Select Date");";")-1);"M/dd/yyyy hh:mm:ss a");"dd-MM-yyyy")
Todate
=FormatDate(ToDate(Substr(UserResponse("Select Date");1;Pos(UserResponse("Select Date");";")-1);"M/dd/yyyy hh:mm:ss a");"dd-MM-yyyy")
Use this if you want to do at report
=Substr(Trim([Interval]);1;10)+":"+Substr(Trim([Interval]);26;10)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Change the format at the universe level itself and use the same object in date prompt.
Regards,
Pranay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.