Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How do I get a Date from a week number?

Tags:

ruby

ruby-on-rails

I want to find all items created in a given week, and pass in a week number param. (created_at is a normal timestamp.)

Given a week number, what is the easiest way to find a date in that particular week? (Any date in the week will do, as I will use beginning_of_week and end_of_week in the scope.)

like image 787
Martin Svalin Avatar asked Dec 08 '10 15:12

Martin Svalin

People also ask

How do I convert a week to a date in Excel?

Select a blank cell you will return the week number, enter this formula: =WEEKNUM(B1,1), and press the Enter key. See screenshot: Notes: (1) In above formula, B1 contains the date that you want to use.

How do you find the start date from the week?

Note: This formula =A2-WEEKDAY(A2,2)+1 will return Monday as the beginning of week based on the given date. Select a blank cell you will return the beginning of week, and enter the formula =A2-MOD(A2-2,7) (A2 is the cell with given date) into it, and then drag the Fill Handle to the range as you need.

1 Answers

You can get Date objects representing the beginning and end of your week using the commercial method:

week = 41;  wkBegin = Date.commercial(2010, week, 1) wkEnd = Date.commercial(2010, week, 7)

Now do your find:

  Item.find(:all, :conditions->:create_date=>wkBegin..wkEnd.end_of_day)
like image 54
Jacob Mattison Avatar answered Oct 10 '22 07:10

Jacob Mattison
Sign in to Comment

Related questions

After logout, if I push back button I can see the last page which requires login
Why do I get "Unknown validator: 'MessageValidator'"?
Rails dependent which options are possible?
RSpec send_file testing
How can an ActiveRecord::Relation object call class methods
How to detect browser type and its version
Deploy PHP to Heroku
Get a particular key value from json in ruby
Adding a default value to text-input in simple-form
How to set up Postgres database for local Rails project?
Can I host images in heroku? Or do I need S3?
Loop & output content_tags within content_tag in helper
Difference between save(false) and save(:validate => false)
Accessing controller instance variables from within an rspec controller spec
new to rails, setting up db then running rake db:create/migrate
Rails - Validation :if one condition is true
How can I use FactoryBot in db/seeds?
accepts_nested_attributes_for rails 4 is not deleting
Migration to change default value for a field and change all existing record's value to new default value only if it has old default value.
Devise raises error with Rails 4.2 upgrade

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!