This is a really common mistake. As you wrote in the date used by the area, this is the date it was downloaded. If you started it in production, when the code rebooted only when the application was restarted (unlike development, where it reboots for each request), you will get the correct results on the day you restarted the application, but the next day the results will be one day, the next day for 2 days, etc.
The correct way to define such an area is
scope :active_drawings, lambda { where('start_date <= ? AND end_date >= ?', Date.today, Date.today)}
The lambda ensures that these dates will be evaluated every time the area is used.
source share