on 12-30-2010 12:23 PM
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.
=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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.