Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Rails date comparison; date greater or equal to days ago

A date in my database looks like this: 2012-07-23

I am trying to see if the date is older than 7 days ago and less than 14 days ago or see if the date is greater than 14 days ago, but am having no luck..

Here is my code:

def progress_report_status_check(date)
    progress_date = date.to_date
    seven_days = 7.days.ago.to_date
    fourteen_days = 14.days.ago.to_date

    if seven_days > (progress_date - 7.days.ago.to_date) or (progress_date - 14.days.ago.to_date) < fourteen_days
      "due"
    elsif (progress_date - 14.days.ago.to_date) > fourteen_days 
      "overdue"
    end 
  end
like image 797
dennismonsewicz Avatar asked Aug 02 '12 01:08

dennismonsewicz


1 Answers

def progress_report_status_check(progress_date) # Pass in a date
  if (progress_date < Date.now-14.days)
    "overdue"
  elsif (progress_date < Date.now-7.days) 
    "due"
  end 
end

or (less readable)

def progress_report_status_check(progress_date) # Pass in a date
  (progress_date < Date.now-14.days) ? "overdue" : ((progress_date < Date.now-7.days) ? "due" : "") : "" 
  end 
end

Depending on your usage you may want to create named scopes, say:

scope :overdue where(:progress_date < Date.now-14.days)
scope :due where(:progress_date < Date.now-7.days)

Then your calling code can be something like

def progress_report_status_check(progress_date) # Pass in a date
  self.overdue? ? "overdue" : self.due? ? : "due" : ""
  end 
end
like image 154
Michael Durrant Avatar answered Sep 24 '22 06:09

Michael Durrant