how many business are left in a month

[vblack7770]

I am an experienced crystal user. Developing in CR 8.5 with Oracle ODBC connecting to Orace 9i DB. I am working on the following:

How many business days are in the Month(currendate)?
How many business days are left in the Month(currentdate)?
How many business days have passed in the Month(currentdate)?

Obviously, if I can get two of these, I can use then to calc the third.

 

[lbass]

I think you can adapt Ken Hamady's formula:

http://www.kenhamady.com/form01.html

You could use the following for the start date:

currentdate - day(currentdate)+1

For the end date, use:

dateadd("m",1,currentdate - day(currentdate) + 1)-1

-LB

 

[vblack7770]

Returning the # of days between two days is not what I needed. I actually want counts for the following:
How many business days are in the Month(currendate)?
How many business days are left in the Month(currentdate)?
How many business days have passed in the Month(currentdate)?

 

[lbass]

Using the dates I suggested would give you the # of business days for the current month. I assumed you could adapt that. A second formula would use the currentdate for the end date, but would otherwise be the same. Then subtract the second from the first.

-LB

 

[vblack7770]

Oh!! I figured out what you meant. Thanks loads for the help as usual!!!