Help me with Date time manipulation
Posted on 2013-06-26
I have a date stamp, let
6/24/2013 9:32:04 PM
i want to deduct 7 hours
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
but it does not work exactly
So the question is how to deduct hours from the date?