End date parameter 12:00 AM

building reports desktopintelligence
1

Hi, Business Object newbie here. Having problems with end date prompt on
report. We are using prompt of ‘>= Begin date and <= End date’. When user
selects date range, both dates are forced to 12:00AM in B.O. This is OK for
‘Begin’ date, but for ‘End’ date it causes rows with times between midnight
and 11:59:59 pm on the end date not to show up on the report. We’ve been
modifying the sql to add one day to the end date and then use ‘less than’
that date. Is there a better way to do this?

We are using Business Objects 4.1 on SQL server 6.5 database. Thanks!
Marti

Listserv Archives (BOB member since 2002-06-25)

2 
    You wrote
    ... 12:00AM in B.O. This is OK for

‘Begin’ date, but for ‘End’ date it causes rows with times between
midnight
and 11:59:59 pm on the end date not to show up on the report. We’ve been
modifying the sql to add one day to the end date and then use ‘less than’
that date. Is there a better way to do this?

    When you choose your dates, you can easily double click on the end

date and modify the 12:00:00 AM to 11:59:59 PM. You shouldn’t have to do
any modifying to the SQL.
Michele

Listserv Archives (BOB member since 2002-06-25)