Roman F
asked on
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([DateToConver t];-1)---- --gives me subtraction of 1 day or 24 hours.
7 hours is 0.29 of 1 day and i can use this
= RelativeDate([DateToConver t];-0.29)
but it does not work exactly
So the question is how to deduct hours from the date?
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([DateToConver
7 hours is 0.29 of 1 day and i can use this
= RelativeDate([DateToConver
but it does not work exactly
So the question is how to deduct hours from the date?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much
then you subtract the hours using this example~!