Get all months names between two given dates

Question

I am trying to make a function which gives all month name between two dates in c#

List<string> liMonths = MyFunction(date1,date2);

my function is

MyFunction(DateTime date1,DateTime date2)
{

//some code
return listOfMonths;
}

can you help me how could i do this

Should the names of the months of `date1` and `date2` be included in the result? — ykb, Sep 06 '13 at 08:47
@Suhan the OP is asking for the names, not the number of months — Panagiotis Kanavos, Sep 06 '13 at 08:49
[Please see this](http://stackoverflow.com/questions/11930565/list-the-months-between-two-dates) — Microsoft DN, Sep 06 '13 at 08:54
Similar question: https://stackoverflow.com/questions/19827148/easy-way-to-loop-over-months-and-years-from-a-given-date — Huseyin Yagli, Oct 04 '17 at 13:56

sloth · Accepted Answer · 2013-09-06T09:19:42.847

36

No linq-solution yet?

var start = new DateTime(2013, 1, 1);
var end = new DateTime(2013, 6, 22);

// set end-date to end of month
end = new DateTime(end.Year, end.Month, DateTime.DaysInMonth(end.Year, end.Month));

var diff = Enumerable.Range(0, Int32.MaxValue)
                     .Select(e => start.AddMonths(e))
                     .TakeWhile(e => e <= end)
                     .Select(e => e.ToString("MMMM"));

edited Sep 06 '13 at 09:19

answered Sep 06 '13 at 08:51

sloth

99,095
21
171
219

This is a better solution than the "This question already has an answer here:". – Høgsdal Feb 08 '17 at 05:04

score 6 · Answer 2 · edited Nov 28 '17 at 15:19

You can use Linq with a helper function

IEnumerable<DateTime> GetDates(DateTime date1, DateTime date2) 
{
    while (date1 <= date2) 
    {
        yield return date1;
        date1 = date1.AddMonths(1);
    }

    if (date1 > date2) 
    { 
        // Include the last month
        yield return date1;
    }
}

Then MyFunction can be one of the following

1) Include year name

List<string> MyFunction(DateTime date1, DateTime date2) {
    return GetDates(date1,date2).Select(x => x.ToString("MMMM yyyyy")).ToList();
}

2) Just the month name, with duplicates

List<string> MyFunction(DateTime date1, DateTime date2) {
  return GetDates(date1,date2).Select(x => x.ToString("MMMM")).ToList();
}

3) Distinct month names

List<string> MyFunction(DateTime date1, DateTime date2) {
    return GetDates(date1,date2).Select(x => x.ToString("MMMM")).Distinct().ToList();
}

Joe Taras · Answer 3 · 2015-11-05T11:34:42.950

5

Create a loop starts date1 until date2. Add one month for every step of your loop and fill in your return variable the month.

I try to write in meta language your aim:

DateTime currDate = date1
List myList = new List();
while (currDate < date2) {
    myList.add(getMonthName(currDate));
    currDate = currDate.addMonth(1);
}

edited Nov 05 '15 at 11:34

answered Sep 06 '13 at 08:46

Joe Taras

15,166
7
42
55

I used you code and realized that `addMonth(1)` doesn't change the value of currDate, you will have to assign `currDate.addMonth(1)` to a new variable and reassign that variable to `currDate` so as to change its value. Simply do this `while (currDate < date2) { mylist.Add(getMonthName(currDate)); var newDate = currDate.AddMonths(1); currDate= newDate; }` – Dev Nov 05 '15 at 10:38
1

Hi, I've fixed my answer. with currDate = currDate.addMonth(1); – Joe Taras Nov 05 '15 at 11:35

Dzmitry Martavoi · Answer 4 · 2013-09-06T09:11:06.100

2

DateTime from;
DateTime to;


var source = from.Month > to.Month ?
               Enumerable.Range(from, 12).Concat(Enumerable.Range(1, to.Month))
             : Enumerable.Range(1, 12)
               .SkipWhile(m => m >= from.Month)
               .TakeWhile(m => m <= to.Month)
var monthes = source
     .Select(m => CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(m));

edited Sep 06 '13 at 09:11

answered Sep 06 '13 at 08:53

Dzmitry Martavoi

6,867
6
38
59

1

Its nice, but think it will fail if your after November to May. – Sayse Sep 06 '13 at 08:55
1

@Sayse: yes, sure. updated. – Dzmitry Martavoi Sep 06 '13 at 09:12
1

It also fails when your after April 2013 - April 2014, but this may be out of scope of question :) – Sayse Sep 06 '13 at 09:20

score 1 · Answer 5 · answered Sep 06 '13 at 08:49

    List<string> MonthNames(DateTime date1, DateTime date2)
    {
        var monthList = new List<string>();

        while (date1 < date2)
        {
            monthList.Add(date1.ToString("MMMM/yyyy"));
            date1 = date1.AddMonths(1);
        }

        return monthList;
    }

score 1 · Answer 6 · answered Sep 06 '13 at 08:56

1

static IEnumerable<DateTime> monthsBetween(DateTime d0, DateTime d1)
{
    return Enumerable.Range(0, (d1.Year - d0.Year) * 12 + (d1.Month - d0.Month + 1))
                     .Select(m => new DateTime(d0.Year, d0.Month, 1).AddMonths(m));
}

answered Sep 06 '13 at 08:56

Microsoft DN

9,706
10
51
71

Alyafey · Answer 7 · 2013-09-06T09:47:22.953

private static List<string> MyFunction(DateTime date1, DateTime date2)
        {

            var listOfMonths=new List<string>();
            if (date1.CompareTo(date2) == 1)
            {
                var temp = date2;
                date2 = date1;
                date1 = temp;
            }

            var mosSt = date1.Month;
            var mosEn = date2.Month;
            var yearSt = date1.Year;
            var yearEn = date2.Year;

            while (mosSt < mosEn || yearSt < yearEn)
            {
                var temp = new DateTime(yearSt, mosSt, 1);
                listOfMonths.Add(temp.ToString("MMMM", CultureInfo.InvariantCulture));
                mosSt++;
                if (mosSt < 13) continue;
                yearSt++;
                mosSt = 1;
            }

            return listOfMonths;
        }

Get all months names between two given dates

7 Answers7

Linked