Forum Discussion
Calendar Based on Last Date
So there should be another 2 table which should list down the Customer wise service frequency. Please share all possible information for solving this problem. Also, for the file that you shared above, please show the exact dates you are expecting for any 2-3 customers (who have different service frequencies). If at all, i can solve the problem, I'd like to compare my answers with yours before i can share the solution file with you.
Good Monring Ashish_Mathur ,
I have updated the sample to include each service frequency as well as actual servie dates for each customer that has different service frequencies. Basically the service frequency is actually based on days. So if the customer is monthly, it is 28 days apart, Every Other Month is 56, etc etc. thanks again for all your help as this resolution will really hep me out.
Updated Sample File
Good morning dmutka. I took a look at the file and one challenege will be for the thrice and twice weekly customers. For example, for customer A you have Sat - Wed - Fri (which can be extrapolated as Wed - Fri -Sat), and for Customer B you have Tue - Thur. Are the service days of the week consistant? If there is no pattern then you could use the average of days between visits (every 2.3 for thrice and 3.5 for twice) to populate a table.
dmutka wrote:Good Monring Ashish_Mathur ,
I have updated the sample to include each service frequency as well as actual servie dates for each customer that has different service frequencies. Basically the service frequency is actually based on days. So if the customer is monthly, it is 28 days apart, Every Other Month is 56, etc etc. thanks again for all your help as this resolution will really hep me out.
Updated Sample FileHi,
I am sorry but i dont think i can solve this. Someone else will help you.
