Computer Learning Zone
Calculating Overlapping Date Ranges in Microsoft Access
23:33
Need to know how many calendar days two date ranges have in common? This episode covers a simple, reusable VBA approach for Microsoft Access that works whether ranges partially overlap, one contains the other, or they do not overlap at all.
The key is to identify the later start date and earlier end date, then handle the important no-overlap check before calculating the result. Richard also…