What if I were to have the application pass in two sets of date ranges? For the condition of Dec 22 to Mar 22:
Dec 22 would become: - Dec 22 - Dec 31 Mar 22 would become: - Jan 1 - Mar 22 The first range would always be for the current year; the second range would always be for the year following the current year. Would that allow PostgreSQL to use the index? Dave