Someone help me..

system · February 13, 2006, 8:33am

Hi… I am a new user of BO, using 6.5.1 v.

The object is in format of “create time details”, it dosent show any value in the “show value” ,while running query, and when I try to input a value, it shows a format …“mm/dd/yyyy hr.min.sec”.
Now I need to find data set between say 12/11/2005 and 01/02/2006(only between 18.00.00 hours and 06.00.00 hours everyday.)
When I put (“between 12/11/2005 18.00.00 and 01/02/2006 18.00.00”) it in the “enter new constant”, it generates a report that starts from 12/11/2005 18.00.00 till 01/02/2006 06.00.00, covering 24 hrs cycle.

Someone help me…

gautkuma (BOB member since 2006-02-03)

system · February 13, 2006, 8:45am

Hi and welcome to B B,

you need to use 3 conditions with AND and OR operators. Something like this:


  <date object> between 12/11/2005 and 01/02/2006
  AND
   (<time object> between 18:00:00 and 23:59:59
    OR
    <time object> between 00:00:00 and 06:00:00
   )

For such conditions you must have 2 separate objects ( and ) in your universe.

Marek Chladny (BOB member since 2003-11-27)

system · February 13, 2006, 9:49am

Thanks.

the problem is that the format for date object as well as time object is shown as mm/dd/yy hr/min/sec when I try to type in a new new constant. The time object takes by default 12/30/1989 as the default date!

gautkuma (BOB member since 2006-02-03)

system · February 13, 2006, 9:55am

Hi,

go to your BO install folder and find the .SBO file. Check the setting of InputDateFormat parameter there.

Marek Chladny (BOB member since 2003-11-27)

system · February 13, 2006, 10:17am

hi…

Thanks a lot. But what if the database is from Universe owned by corporte ? Cant we write some code to get the dersired data within a time frame?

gautkuma (BOB member since 2006-02-03)

system · February 13, 2006, 10:26am

Hi,

please redefine your question, I somehow do not understand what you are asking or what is the problem.

Marek Chladny (BOB member since 2003-11-27)

system · February 13, 2006, 10:51am

Hi…

In the universe, there are objects nameed “problem create date” and “problem create time”, both with format mm/dd/yyyy hr/min/sec. I need to retrieve data which is between 11/11/2005 and 02/06/2006,and for those problems that have occured between 18.00 hrs and 06.00 hrs for each of these day.
So, I ran a query. In conditions, I used "Problem create date: between 11/11/2005 18.00.00 and 02/06/2006 06.00.00. And 'Problem create time which is supposed to be "Problem create time between 18.00.00 and 06.00.00. But even for problem create time object , the format that appears while typing the new constant appears as mm/dd/yyyy hr/min/sec.
In that case, I have to mention a date even in "problem create time"also. If I dont mention anything there, a default date of 12/30/1989 is taken, and the report does not return any result.
The generated report shows all the problems that have occured from 11/11/2005 6 pm till 02/06/2006 6am, whereas I want something else.

I am working on corporate database. So, I cant alter the imput parameters.

Pls get me out of the mess.

gautkuma (BOB member since 2006-02-03)

system · February 13, 2006, 10:56am

Hi,

are you allowed to do changes in the appropriate universe?

If yes then open it and see what format of date/time is used for the conditions that you use in the report. If it is possible, change this format to the one you need.

Marek Chladny (BOB member since 2003-11-27)

system · February 13, 2006, 10:59am

Hi…
I cant change the universe format. lots of data dependencies. Can something be done through coding…

gautkuma (BOB member since 2006-02-03)

system · February 13, 2006, 11:57am

What about some new universe objects formatted the way you want?

For some VBA condition coding please have a look for example here or here. Or do a search in BOB.

Marek Chladny (BOB member since 2003-11-27)

system · February 13, 2006, 12:00pm

Hi.

The universe is outsourced to other company. i have contacted them for editing the format. thanks a lot friend.

gautkuma (BOB member since 2006-02-03)

system · February 13, 2006, 7:26pm

You could have simply run the report for the day after the current date you want, and then apply a filter to the field in question to remove those extra hours retrieved by the report.

MoonDragn (BOB member since 2004-05-12)

system · February 13, 2006, 8:12pm

Hi,
I believe that your problem stems from the fact that both your prompt objects are defined as date objects. What this provides is that in the design applying a mm/dd/yyyy format to a date value does not strip the time portion from the database. Also putting the date as mm/dd/yyyy will default to the datetime value at mid night (02/13/2006 00:00:00). The same applies to the time object defined as date (for databases like oracle the date and datetime is the same. Only formatting shows then differently).

The work around is to modify the objects at the universe level to make the time object a character or numeric object for the hour of the day.

If you cannot modify the universe then pull both objects as part of the report using the same values for both.

At the report level create filters for the time values that you are interested in. (You may have to create objects that represent the hour of the day from the datetime fields.)

seanikom (BOB member since 2004-12-30)