Sir I have some date series in to field, start date and end date, like 1/03/2020 - 31/03/2020 like that, and countiniously
next is 01/04/2020 to some other date...But some cases next start date may not continues, it may 05/04/20 instead of 01/04/2020. I want to find out the missing period, ie, 01/04/2020 to 04/04/2020 (missing period). How can i find out this missing period in msaccess data base.Pls help me...
Start Date End date
1/03/2020 31/03/2020
05/04/2020 30/06/2020 How to find the missing period, ie, 01/04/2020 to 04/04/2020 by using query or other any method....I am a beginner
01/07/2020 31/12/2020