OTBI-ORC report issue on filter of candidate job application date

Summary:

HI Team,

when we apply the filter of candidate job application date  report running long time without result but when we remove the filter on date it takes only less than one miniute.

reason of applying the filter on to redcuce the data: candidate job application date  greather than or equal to 2023.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):