Date Calculations

[Acydman]

I want to calculate two numbers, one is the number of days (excluding weekends) that have passed month to date and the other is the number of days remaining in the month (again excluding weekends)

I am writing this in Crystal Reports 9

Thanks

Mark

 

[lbass]

You should be able to adapt Ken Hamady's formula for work days for this:

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

You would use:

currentdate-day(currentdate)+1

...for Start and Currentdate for End in one formula, and for the second, use currentdate for Start and use:

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

for End in the other formula.

-LB

 

[BobSuruncle]

Hi Mark,

You could try the following two formulas:

1.) @DaysSoFar

Global DateVar tdy := CurrentDate ;
Local Datevar first := Date(Year(tdy), Month(tdy),1) ;
Local NumberVar since ;

since := ( DateDiff('d',first,tdy) 
            - DateDiff('ww',first,tdy,crsaturday) 
            - DateDiff('ww',first,tdy,crSunDay) ) +1;

2.) @DaysToGo

Global DateVar tdy ;
Local Datevar last := DateSerial(Year(tdy), Month(tdy)+1,1-1) ;
Local NumberVar togo ;

togo := ( DateDiff('d',tdy,last) 
            - DateDiff('ww',tdy,last,crsaturday) 
            - DateDiff('ww',tdy,last,crSunDay) ) ;

Bob Suruncle