BusinessObjects Board

Adding hours to a time field

I am building a report that needs to show the time that a work item was sent to a particular work queue. The object is a dttime field, and I formatted it to show time only:

=FormatDate(, “HH:mm:ss”)

The problem is that there is an inconsistency between the source data and the universe (I think due to daylight savings issues) where the source system which is correct might say 6pm, but the data in BusObj says 5pm. So I am looking to add 1 hour to all my times, but am having trouble accomplishing this.

Any help would be greatly appreciated.


JPritch (BOB member since 2004-12-29)

Hi,

It’s not a nice and simple formula but it should work:


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

Marek,

Doesn’t have to be pretty as long as it works, and works it does! Thank you sir!


JPritch (BOB member since 2004-12-29)

I am glad to hear that it works for you and you found it useful. 8)


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

A Simple Formula. Hope it helps.

=FormatDate(CurrentDate() ,“dd-mm-yyyy”)+" “+(FormatDate(CurrentDate() ,“HH”)+1)+FormatDate(CurrentDate() ,”:mm:ss")

Regards,
Rangu


rangu (BOB member since 2010-05-28)

Yes, a simple formula but my guess is that it would not work when adding 1 hour changes also the date part of the datetime.


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

Can you please illustrate with an example?..


rangu (BOB member since 2010-05-28)

When CurrentDate() will be for instance 25-Oct-2010 23:30:12


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

wat is the expected result here?..


rangu (BOB member since 2010-05-28)

Maybe 26-Oct-2010 00:30:12? :slight_smile:


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

U are right… It will not work… I tested it… Will try to find a simple formula… :smiley:


rangu (BOB member since 2010-05-28)