Days Between Dates excluding the Weekends

building reports desktopintelligence
1

Guys,
I have two date fields say start date and end date.I need to find out the days between these two dates excluding Weekends(saturday and sunday’s).

I did  search the forum on this and found a very good solution on the database side. Is there any way to do this in the reporter or even the designer.

 Thank you.

Oracle 10g
B.O 5.1.7

bluebox (BOB member since 2004-05-28)

2

Please, see if this thread is of any help.

Andreas :de: (BOB member since 2002-06-20)

3

Hi Gopi,

Create three variables in the report.

Number of Weekends: =Truncate((DayNumberOfWeek()+DaysBetween( ,)) /7 ,0)

Non Working Days: = *2

Number of days : =Floor((DaysBetween( ,)-))

good luck.

murali :new_zealand: (BOB member since 2002-08-16)

4

THANK YOU.

Gopi

bluebox (BOB member since 2004-05-28)

5

Hi,

When i try to use this for dates 6/3/2007 and 6/5/2007 it gives me 0 days.

Please find the screen shot.
For 2nd and 3rd calculation the not working days is 2.
But for the second one it should be only one.

??.Am i missing something.

Thanks,
–H
daysbetween2.jpg

hourigan (BOB member since 2007-04-06)

6

Check your date format whether it is mm-dd-yyyy or dd-mm-yyyy then check your no of days formula…

vijaykollu :us: (BOB member since 2003-05-08)

7

Its in mm dd yyyy.And if we calculate using the formuale the results do not work out.

Thanks,–h

hourigan (BOB member since 2007-04-06)

8

try other way…

create 2 separate objects or variables to find out the days then subtract it

days(Date1)
days(Date2)

No of days = (days(Date1) - days(Date2))

vijaykollu :us: (BOB member since 2003-05-08)

9

Can you please explain in detail.How can i create seperate objects for each date???

Thanks,–h

hourigan (BOB member since 2007-04-06)

10

Hi hourigan,

I am having similar problem.I need to calculate working days between two date range excluding weekends.I have worked around with some formula’s but no results.If you got solution for your problem can you please share.

Thanks
Anil

KAnil (BOB member since 2008-12-23)

11

Hi All-

I’m having the same problem and I have yet to figure this out…

I tried the suggestions above, but still no positive results.

Anyone know the answer?.. Help, help, help… pls!

wm.

willop (BOB member since 2009-02-20)

12

You might try and see if this thread helps. Calculation is displayed in the last couple of posts.

MBTDC :us: (BOB member since 2007-12-28)

13

The other post is extremely difficult to understand thus apply to our scenario, does any1 know if the above suggestion works for sure? thanks.

showt2 (BOB member since 2009-05-11)