New to the forum here, but I have been working with Access for some time. Using Office 365 Pro Plus. I have a situation I cannot figure out. I have a table that contains dates of service, and I need to drop any date of service that is <14 days apart. A sample of some of the dates of service, and number of days to next:
10/8/2018 7 days
10/15/2018 10 Days
10/25/2018 20 Days
11/14/2018
So, from this batch I only want to drop the 10/15/2018 date. 10/8/2018 to 10/25/2018 is 17 days, so that date is ok. But of course it is reading the 10/15/2018 prior date so it looks like it should be dropped. I am using the DateDiff function to calculate all the days, but I am not sure what to do to keep in the 10/25/2018 date. I do not know how to use VBA, so if that is the only solution, I will need some hand holding to make it work. Thanks for your assistance.
10/8/2018 7 days
10/15/2018 10 Days
10/25/2018 20 Days
11/14/2018
So, from this batch I only want to drop the 10/15/2018 date. 10/8/2018 to 10/25/2018 is 17 days, so that date is ok. But of course it is reading the 10/15/2018 prior date so it looks like it should be dropped. I am using the DateDiff function to calculate all the days, but I am not sure what to do to keep in the 10/25/2018 date. I do not know how to use VBA, so if that is the only solution, I will need some hand holding to make it work. Thanks for your assistance.