I'm try to write a spec for a named scope which is date dependent.

The spec:

it "should return 6 months of documents" do
    Date.stub!(:today).and_return(Date.new(2005, 03, 03))
    doc_1 = Factory.create(:document, :date => '2005-01-01')
    Document.past_six_months.should == [doc_1]
end

The named scope in the Document model:

named_scope :past_six_months,
  :conditions => ['date > ? AND date < ?', Date.today - 6.months, Date.today]

The spec fails with an empty array, and the query in test.log shows why:

SELECT * FROM "documents" WHERE (date > '2009-11-11' AND date < '2010-05-11')

i.e. it appears to be ignoring my stubbed Date method.

However, if I use a class method instead of a named scope then it passes:

def self.past_six_months
    find(:all, :conditions => ['date > ? AND date < ?', Date.today - 6.months, Date.today])
end

I would rather use the named scope approach but I don't understand why it isn't working.