Date Range Between Two Dates - NEED HELP

rubyonrails-talk
#1

hi,

   I've two dates say

  input for example.,
   date1 = '2009-01-02';
   date2 = '2009-01-10';

   Need to find date range array between date1 and date2.

output for example.,
     Array{
     [0]=>'2009-01-02',
     [1]=>'2009-01-03',
     [2]=>'2009-01-04',
     [3]=>'2009-01-05',
     [4]=>'2009-01-06',
     [5]=>'2009-01-07',
     [6]=>'2009-01-08',
     [7]=>'2009-01-09',
     [8]=>'2009-01-10'
     )
Thanks in advance
Shankar.

#2

Shankar Ganesh wrote:

hi,

Hello.

   I've two dates say

  input for example.,
   date1 = '2009-01-02';
   date2 = '2009-01-10';

   Need to find date range array between date1 and date2.

output for example.,
     Array{
     [0]=>'2009-01-02',
     [1]=>'2009-01-03',
     [2]=>'2009-01-04',
     [3]=>'2009-01-05',
     [4]=>'2009-01-06',
     [5]=>'2009-01-07',
     [6]=>'2009-01-08',
     [7]=>'2009-01-09',
     [8]=>'2009-01-10'
     )
Thanks in advance
Shankar.

I'm not entirely clear on what you're looking for. If you already have this data in an array, I suggest using select {}. I.e.

data.select {|x| x >= date1 and x<= date2 }

If you're trying to fetch the data, perhaps you're looking for conditions. I.e.

conditions = [ 'date_column > ? AND date_column < ?', date1, date2 ]

Hope that helps.

Cheers,
Darrik

#3

You can use Date ranges. If you have strings, you'll need to Parsedate
them into dates first. String ranges won't understand date overflow
(ie how many days in a month, months in a year etc.).

((1.year.ago.to_date)..(Date.today)).to_a.map{|x| x.to_s(:db)}

Julian

#4

Julian Leviston wrote:

You can use Date ranges. If you have strings, you'll need to Parsedate
them into dates first. String ranges won't understand date overflow
(ie how many days in a month, months in a year etc.).

((1.year.ago.to_date)..(Date.today)).to_a.map{|x| x.to_s(:db)}

Julian

Thanks for your HELP.
can you explain with example Julian ?

#5

What do you mean?

Blog: http://random8.zenunit.com/
Learn rails: http://sensei.zenunit.com/

#6

hi,

  I've two dates say

input for example.,
  date1 = '2009-01-02';
  date2 = '2009-01-10';

  Need to find date range array between date1 and date2.

output for example.,
    Array{
    [0]=>'2009-01-02',
    [1]=>'2009-01-03',
    [2]=>'2009-01-04',
    [3]=>'2009-01-05',
    [4]=>'2009-01-06',
    [5]=>'2009-01-07',
    [6]=>'2009-01-08',
    [7]=>'2009-01-09',
    [8]=>'2009-01-10'
    )
Thanks in advance
Shankar.

From: Julian Leviston <julian@coretech.net.au>
Date: February 4, 2009 1:08:15 AM EST
To: rubyonrails-talk@googlegroups.com
Subject: [Rails] Re: Date Range Between Two Dates - NEED HELP
Reply-To: rubyonrails-talk@googlegroups.com

You can use Date ranges. If you have strings, you'll need to Parsedate
them into dates first. String ranges won't understand date overflow
(ie how many days in a month, months in a year etc.).

((1.year.ago.to_date)..(Date.today)).to_a.map{|x| x.to_s(:db)}

Julian

Julian gave you almost everything. Are you asking about "Parsedate"?

Try this:

require 'date'
date1 = Date.parse('2009-01-02')
date2 = Date.parse('2009-01-10')
(date1..date2).to_a

puts (date1..date2).to_a

2009-01-02
2009-01-03
2009-01-04
2009-01-05
2009-01-06
2009-01-07
2009-01-08
2009-01-09
2009-01-10
=> nil

Or to make it even more clear, try 2009-02-25 to 2009-03-05

puts (Date.parse('2009-02-25')..Date.parse('2009-03-05')).to_a

2009-02-25
2009-02-26
2009-02-27
2009-02-28
2009-03-01
2009-03-02
2009-03-03
2009-03-04
2009-03-05
=> nil

-Rob

Rob Biedenharn http://agileconsultingllc.com
Rob@AgileConsultingLLC.com