I am currently wanting to know how to find out two different dates from a list of dates for each customer. I can find out the first date for each customer but I need to know their 6 month and 1 year visit.
But the problem is not all the customer will have visited exactly 6 months or a year afterwards. I just need to know how to figure out the closest date to 6 months and a year.
The customers details are currently stored in a table, each having their own unique ID and the visits are stored in a table each with a unique ID.
Any help would be great :)