I have been tasked to determine the Interval between dates of a PM Schedule. Here is a sample of my data:
| EventScheduleID | EventStartDateTime | Frequency |
| 100 | 7/6/2015 | Weekly |
| 100 | 7/13/2015 | Weekly |
| 100 | 7/20/2015 | Weekly |
| 103 | 9/1/2015 | Monthly |
| 103 | 3/1/2016 | Monthly |
| 103 | 9/1/2016 | Monthly |
| 103 | 3/1/2017 | Monthly |
In the database of my client stores the frequency you can see Weekly and Monthly in example. There might be some schedules that are Daily and Yearly as well. There is no Quarterly, Bi-Monthly, Semi-Annually. The way they have to setup Quarterly as you can predict is Monthly and then select every 3 months. Is there a formula that create the words Quarterly, Semi-Annually, etc. I have all the schedules and the start dates for them going out 2 years. So in the example above for Schedule 103 I want to change on the front end Monthly to Semi-Annually. I hope this makes sense. Any suggestions are welcome.
David
