>>
>>lnFullWeeks = max(week(date(),1,2),0)
>>lnFirstWeekDays = max(8-dow(date(year(date()),1,1),2) - 2,0)
>>lnThisWeekDays = iif(week(date(),1,2)=1,0,min(dow(date(),2),5))
>>lnWorkDays = lnFullWeeks * 5 + lnFirstWeekDays + lnThisWeekDays
Yes George,
That happens when your fingers type different than your mind thinks.) max() had a purpose there :)
lnFullWeeks = max(week(date(),1,2)-2,0)
Walter, week() function has optional parameters specifying when a week starts and what fdow is.
Cetin