Will you be able to help me come up with a SQL query that will compute for the next date based on the Recurrence, Interval and Day of week in the Activity (OCLG).
Here's an example:
The Activity is Set to Weekly with an Interval of 1 and the Day of Week is Thursday. The screen on the right is a sample of the list of next dates for the next 6 months. I need a query that will calculate for this that is dependent on the Recurrence (Daily, Weekly, Monthly, Annually) and the interval that can be saved on a #Temp Table. Is this something possible? Thanks in advance