Solved

Help me with Date time manipulation

Posted on 2013-06-26
5
432 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
  • 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 2

Expert Comment

by:eli411
ID: 39278962
0
 
LVL 2

Expert Comment

by:eli411
ID: 39278966
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Introduction Hopefully the following mnemonic and, ultimately, the acronym it represents is common place to all those reading: Please Excuse My Dear Aunt Sally (PEMDAS). Briefly, though, PEMDAS is used to signify the order of operations (http://en.…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

813 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now