Help me with Date time manipulation

I have a date stamp, let
6/24/2013 9:32:04 PM

i want to deduct 7 hours

and get
6/24/2013 2:32:04 PM

In Business Objects i am using the formula :

= RelativeDate([DateToConvert];-1)------gives me subtraction of 1 day or 24 hours.
7 hours is 0.29 of 1 day and i can use this
= RelativeDate([DateToConvert];-0.29)

but it does not work exactly
So the question is how to deduct hours from the date?
Who is Participating?
mlmccConnect With a Mentor Commented:
Which tool are you using?

Is it Crystal?
Crystal has a DateAdd function


Is it WebI?

= RelativeDate([DateToConvert];-7/24)

What doesn't seem to be working?


then you subtract the hours using this example~!
rfedorovAuthor Commented:
Thank you very much
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.