Skip to Content
Nov 20, 2018 at 09:46 PM

BP Activity - Query for next date


Hi Experts,

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



capture.jpg (26.8 kB)