?
Solved

Help me with Date time manipulation

Posted on 2013-06-26
5
Medium Priority
?
448 Views
Last Modified: 2013-06-26
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?
0
Comment
Question by:rfedorov
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 2

Expert Comment

by:eli411
ID: 39278960
http://forums.asp.net/t/1609801.aspx/1

then you subtract the hours using this example~!
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 39279000
Which tool are you using?

Is it Crystal?
Crystal has a DateAdd function

DateAdd("h",-7,{DateField})

Is it WebI?
Try

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


What doesn't seem to be working?

mlmcc
0
 

Author Closing Comment

by:rfedorov
ID: 39279061
Thank you very much
0

Featured Post

Application Discovery Service in AWS

In the era of the cloud, customers migrating away from their existing on-premise infrastructure. This requires lots of planning, strategies, and effort to identify their existing resources and determine how best to migrate.  Datacenter migrations happen in four phases -

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question