BusinessObjects Board

difference between dates

building reports webintelligence
#1

I have a webi report which gets two objects from the universe. One is “project start week” and “project end week”.
This two object format is yyyywk (ex: 200830). So i have to find difference between these two weeks according to each project.

Ex: “PST” is project name, this “project start week” is: 200752, “project end week” is 200804.
Then i have to find, how many weeks b/w these two weeks. :hb:

Any advice here.

Thanks
Rajesh

kanukula (BOB member since 2007-05-05)

#2

Hi kanukula,

You should be able to use something like this to calculate weeks between;
=DaysBetween([Date 1];[Date 2)/7

Joe Szabo :us: (BOB member since 2002-08-19)

#3

This might be helpful to you.

aniketp :uk: (BOB member since 2007-10-05)

#4

Take a look at this topic
The same exact requirement.

KhoushikTTT :us: (BOB member since 2005-02-24)