Split the time period into multiple periods

Question

I have a date range as follows

from = Date.parse('05.01.2017')
to   = Date.parse('10.03.2018')

I want to split the date range by 30 days as follows. I want to include the from and to date.

I found this reference link. But I don't find from and to date in the response. How can I do this?

Expected Output:

05.01.2017 - 03.02.2017
04.02.2017 - 05.03.2017
06.03.2017 - 04.04.2017
...
07.02.2018 - 10.03.2018

The expected output is still not completely clear, but I assume that you want an array of strings that would be printed as such. The output you have does not seem to be grouped by months in any way. Can you expand on that? — sawa, Feb 20 '19 at 11:02
I want 30 days date range for every iteration. So that I can pass the 30 days date range as start and end date to api call to fetch reports. — Galet, Feb 20 '19 at 11:04
That is not a month. It is 30 days range. And still, what you have shown is not grouped in 30 days. For example, take `05.01.2017 - 05.02.2017`. The number of days in that range is (31 - 4) + 5 = 32 != 30. — sawa, Feb 20 '19 at 11:07
`05.01.2017 - 04.02.2017` in your expected output after the edit, is still not 30 days. It is 31 days. — sawa, Feb 20 '19 at 11:12
Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/188747/discussion-between-karan-and-sawa). — Galet, Feb 20 '19 at 11:16
@karan check my answer, just updated on basis of your question update — Gagan Gami, Feb 20 '19 at 11:26

Gagan Gami · Answer 1 · 2019-02-20T11:40:25.310

1

from = Date.parse('05.01.2017')
to   = Date.parse('10.03.2018')

s = from
e = s + 29
begin
  puts "#{s.strftime('%d.%m.%Y')} - #{e.strftime('%d.%m.%Y')}"
  s = e + 1
  e =  (s + 29 < to ) ? s + 29 : to
end while (s < to)

Output:

05.01.2017 - 03.02.2017 # 30 days
04.02.2017 - 05.03.2017 # 30 days
06.03.2017 - 04.04.2017 # 30 days
05.04.2017 - 04.05.2017 # 30 days
05.05.2017 - 03.06.2017 # 30 days
04.06.2017 - 03.07.2017 # 30 days
04.07.2017 - 02.08.2017 # 30 days
03.08.2017 - 01.09.2017 # 30 days
02.09.2017 - 01.10.2017 # 30 days
02.10.2017 - 31.10.2017 # 30 days
01.11.2017 - 30.11.2017 # 30 days
01.12.2017 - 30.12.2017 # 30 days
31.12.2017 - 29.01.2018 # 30 days
30.01.2018 - 28.02.2018 # 30 days
01.03.2018 - 10.03.2018 # remaining days till to (10.03.2018)

NOTE: 01.03.2018 - 10.03.2018 is not 30 days range. but as per OP's comment I have displayed date till to

edited Feb 20 '19 at 11:40

answered Feb 20 '19 at 11:21

Gagan Gami

10,121
1
29
55

I don't find date range upto 10.03.2018 – Galet Feb 20 '19 at 11:23
Still it shows upto 11.02.2018 not a date range upt 10.03.2018 – Galet Feb 20 '19 at 11:28
@karan updated answer, check output – Gagan Gami Feb 20 '19 at 11:29
I need exact date upto 10.03.2018. But still it shows upto 28.02.2018 – Galet Feb 20 '19 at 11:30
1

@karan check the note, 01.03.2018 - 10.03.2018 is not 30 days range. – Gagan Gami Feb 20 '19 at 11:31
But I want to include that range even though it is not 30 days. – Galet Feb 20 '19 at 11:33
@karan : updated my answer – Gagan Gami Feb 20 '19 at 11:35
@karan "But I want to include that range even though it is not 30 days. "--You have not written so in the question. It is impossible to show the days in 30 days and finish on the `to` date at the same time. – sawa Feb 20 '19 at 11:44

sawa · Accepted Answer · 2019-02-20T12:43:05.820

1

require "date"

from = Date.parse('05.01.2017')
to   = Date.parse('10.03.2018')

first = from.jd
(from..to)
.chunk{|date| (date.jd - first) / 30}
.map{|_, (first, *, last)|
  "#{first.strftime("%d.%m.%Y")} - #{last.strftime("%d.%m.%Y")}"
}

Output:

05.01.2017 - 03.02.2017
04.02.2017 - 05.03.2017
06.03.2017 - 04.04.2017
05.04.2017 - 04.05.2017
05.05.2017 - 03.06.2017
04.06.2017 - 03.07.2017
04.07.2017 - 02.08.2017
03.08.2017 - 01.09.2017
02.09.2017 - 01.10.2017
02.10.2017 - 31.10.2017
01.11.2017 - 30.11.2017
01.12.2017 - 30.12.2017
31.12.2017 - 29.01.2018
30.01.2018 - 28.02.2018
01.03.2018 - 10.03.2018

edited Feb 20 '19 at 12:43

answered Feb 20 '19 at 11:42

sawa

165,429
45
277
381

What code needs to be changed if we use following from and to instead of Data.parse. from = Time.find_zone(@time_zone).local(2018,11,01).beginning_of_day and to = Time.find_zone(@time_zone).now.yesterday – Galet Feb 20 '19 at 12:10

Split the time period into multiple periods

2 Answers2