cancel
Showing results for 
Search instead for 
Did you mean: 

how to minus hours from the timestamp

bdachepalli
Explorer
0 Kudos

Hi,

My query is that how do i minus hours from the date/timestamp in the BO Web Intelligence.

Date/timestamp:

12/15/2010 09:10:06

hour1:

25.57166667

hour2:

0

R = date - (hour1+hour2)

R=

12/14/2010 07:35:47

Thank you.

Accepted Solutions (0)

Answers (2)

Answers (2)

amrsalem1983
Active Contributor
0 Kudos
=RelativeDate([Your Date];(-hour1-hour2)/24)

dont forget to format the cell to show the time

good luck

Amr

Edited by: Amr Salem on Jan 5, 2011 2:57 PM

Former Member
0 Kudos

Hi Babu,

What type of output are you expecting from this? Minutes? Hours or Date?

Are you not able to do some sort of DateAdd function in sql?

Thanks