The issue is less the index and more the code. My first recommendation would be to rewrite your query.

Please provide the execution plan, sample data, and expected results sample.