Thanks for the reply. There was data for the dates. What I ended up doing is similar to using a temp table in a way. I didn't use the linked server to the Oracle database. We started a daily pull from the Oracle database into a table in a SQL Server instance and I can query against that with no date issues. So I didn't exactly solve the problem, but found a way around it.

Again thanks for all the help with this.