My query works fine but for the last part as below. I need to retrieve records where the start date <= today and end date is >= today.
I also need the records where the strat date is up to 9 months from today.
This part of the query ensures it returns nothing when there is data to be returned. I have had little success from searching and reading the docs.
Please give me a nudge.