>Hi there. I tried to find the "Stupid Questions" category for this one, but it didn't exist. :) Is there a way to count the number of business days (which would be everyday but Sat. and Sun.) that have occurred from Jan. 1st to today? just wondering....tia.
Probably not the most elegant way, but it's fast
ldStart = DATE(YEAR(DATE()), 1, 1)
lnBusDays = 0
FOR ji = 0 TO DATE()-ldStart
IF !INLIST(CDOW(ldStart+ji),"Saturday","Sunday")
lnBusDays = lnBusDays + 1
ENDIF
ENDFOR
Of course, there could be holidays (like July 4th) which might not be considered business days.
Insanity: Doing the same thing over and over and expecting different results.