BusinessObjects Board

Date and Time Issue

If I have a date and time filed in BO, How can I find the difference in the number of hours using standard functionality in BO?

I have a field in the following format: “12/30/2008 12:01:00 AM”

If I have another field: 12/31/2009 2:01:00 AM what is the way to tell the difference in the date and time in number of hours or days and hours?

welbonr :us: (BOB member since 2009-11-23)


It should have been 12/31/2008 2:01:00 AM

welbonr :us: (BOB member since 2009-11-23)


This old topic should get you started:

The formulas in the topic are for DeskI but it should not be a problem to convert them into formulas for WebI.

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