Hi,

I try to retrieve the first and last day of previous month to build a query with a range date.

Right now I’m doing this:

def foo(%DateTime{month: month, year: year} = current_date) do

  # eg. 2019-01-01 00:00:00
  start_date = %{current_date | month: month - 1, day: 1, hour: 00, minute: 00, second: 00}

  days_of_month = DateTime.to_date(start_date) |> Date.days_in_month()

  # eg. 2019-01-31 23:59:59
  end_date = DateTime.add(start_date, (days_of_month - 1) * 86_400 + 86_399, :seconds)

  ...
end

For the moment I don’t handle the year change , but before continuing I wanted to know if you had another way of doing it.

Thanks