[SanmanX]

Hey guys i need help with my code. I'm trying to write a query where it finds all permits sold by a user within a date range. Here is what i have in my controller:

def report
	
 @performance_report = PerformanceReport.new(params[:performance_report])
    @users = User.find_by_spire_ID(params[:performance_report][:spire_ID])
		@permits = Permit.find_all_by_created_user_ID_and_date(@users.id, :start_date > :end_date )
 respond_to do |format|
	format.html #report.html.erb
  format.json {render json: @performance_report}
 end
end

I'm guessing that is not the right way to compare dates.

[Skaggles]

Try using a range of dates, such as:

@users = User.where(:creation_date => FIRST_DATE..END_DATE)

This post has been edited by Skaggles: 04 June 2012 - 02:37 PM

[SanmanX]

Thx for the help but i figured it out from this place:
http://morecode.word...-ruby-on-rails/

So i just did:

@users = User.find_by_spire_ID(params[:performance_report][:spire_ID])
		@permits = Permit.find(:all, :conditions => {:created_user_ID => @users.id, :date_issued =>@performance_report.start_date..@performance_report.end_date})