cancel
Showing results for 
Search instead for 
Did you mean: 

Date interval issue

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

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

former_member4998
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

Try this

=ToDate(Substr([Interval];1;Pos([Interval];"M"));"MM-dd-yyyy hh:mm:ss a")+":"+ToDate(Substr([Interval];Pos([Interval];"M")+3;Length([Interval]));"MM-dd-yyyy hh:mm:ss a")

sateesh_kumar1
Active Contributor
0 Kudos

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")

Former Member
0 Kudos

Use this if you want to do at report

=Substr(Trim([Interval]);1;10)+":"+Substr(Trim([Interval]);26;10)

former_member203850
Contributor
0 Kudos

Change the format at the universe level itself and use the same object in date prompt.

Regards,

Pranay