?
Solved

Help me with Date time manipulation

Posted on 2013-06-26
5
Medium Priority
?
457 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 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

850 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