BusinessObjects Board

Business days between

building reports desktopintelligence

system November 13, 2007, 9:35pm 4

Try:

120×120 10.4 KB

Days Between Dates excluding the Weekends desktopintelligence

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)

or

120×120 10.4 KB

Days Difference desktopintelligence

In a message dated Thu, 1 Mar 2001 7:01:49 AM Eastern Standard Time, Ted Michalski tmichal1@FORD.COM writes: << Here’s a good one. I need to calculate the number of days between two dates. Normally not a problem… but I don’t want to count weekends in the calculation. So if I wanted to get the number of days between today (Wednesday) and last Tuesday, I need to result to be 6 (8 total days - the two weekend days). Has anyone ever had to do this? Here’s something to get you started: it’s not per…

Andreas (BOB member since 2002-06-20)

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled