Improve company productivity with a Business Account.Sign Up

x
?
Solved

Problem with Business Objects DaysBetween

Posted on 2011-03-15
1
Medium Priority
?
1,469 Views
Last Modified: 2012-06-21
Hi all,
i have a very strange and bizarre problem using webi version of business objects XI.
I used a days between function to determine the age of two dates...but for some reason the day turns the next day at 6PM. My tech support has not been able to find a solution. Any ideas, experts? see below the images of the result:

the formula i am using for age is:

=DaysBetween([Query 1].[Actual Start Time];[Current Date])

below i am showing both values and see that the Age jumps one day at 6pm...a day later.

 age1age2.jpg
0
Comment
Question by:sassy168
1 Comment
 
LVL 7

Accepted Solution

by:
Cboudroz earned 2000 total points
ID: 35140617
I didn't work whit business objects XI since a will, but Looks like if it's link to timezone.

Are you in time zone (GMT -6)?

You can change your windows TimeZone to see if he change the formula result (if you put GMT -4 you should see a difference after 8pm instead of 6pm).

I think you can used SQL formula instead of business objects formula.

T-SQL:
DATEDIFF(dd, [actual start Time], getdatE())
0

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

608 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