Solved

Help me with Date time manipulation

Posted on 2013-06-26
5
426 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
Comment Utility
http://forums.asp.net/t/1609801.aspx/1

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

Expert Comment

by:eli411
Comment Utility
0
 
LVL 2

Expert Comment

by:eli411
Comment Utility
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
Comment Utility
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
Comment Utility
Thank you very much
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

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…
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

743 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

17 Experts available now in Live!

Get 1:1 Help Now