B bugsy Registered User. Local time Today, 07:56 Joined Oct 1, 2007 Messages 99 Nov 5, 2007 #1 I've had it before, but can't find it. basically something like this -- Code: DateDiff("w", StartingDate, EndingDate) that also makes sure date is not in tblHolidays. anyone knows how to acomplish this ?
I've had it before, but can't find it. basically something like this -- Code: DateDiff("w", StartingDate, EndingDate) that also makes sure date is not in tblHolidays. anyone knows how to acomplish this ?
B bugsy Registered User. Local time Today, 07:56 Joined Oct 1, 2007 Messages 99 Nov 5, 2007 #2 i found it; here it is Code: # of Days Stale: DateDiff('d',[date],Date())-(DateDiff('ww',[Date],Date())*2)-(Select Count(*) from [tblHolidays] where [HolidayDate] between [date] and date())
i found it; here it is Code: # of Days Stale: DateDiff('d',[date],Date())-(DateDiff('ww',[Date],Date())*2)-(Select Count(*) from [tblHolidays] where [HolidayDate] between [date] and date())
