List the months between two dates

Question

I would like to know when given start and end dates, how can the months and year(s) between the two dates be retrieved.

Eg: Start Date: '1/1/2011'(mm/dd/yyyy) and End date :'11/30/2011'. The months and year to be retrieved are January,2011; February,2011; March,2011; and so on till November,2011

Answer 1

Here we go

public static IEnumerable<(string Month, int Year)> MonthsBetween(
        DateTime startDate,
        DateTime endDate)
{
    DateTime iterator;
    DateTime limit;

    if (endDate > startDate)
    {
        iterator = new DateTime(startDate.Year, startDate.Month, 1);
        limit = endDate;
    }
    else
    {
        iterator = new DateTime(endDate.Year, endDate.Month, 1);
        limit = startDate;
    }

    var dateTimeFormat = CultureInfo.CurrentCulture.DateTimeFormat;
    while (iterator <= limit)
    {
        yield return (
            dateTimeFormat.GetMonthName(iterator.Month), 
            iterator.Year
        );

       iterator = iterator.AddMonths(1);
    }
}

And obviously you call it like this

var startDate = DateTime.ParseExact("01/01/2011", "MM/dd/yyyy");
var endDate = DateTime.ParseExact("11/30/2011", "MM/dd/yyyy");

var months = MonthsBetween(startDate, endDate);

The results should be something like

{
    {  "January", 2011  },
    {  "February", 2011  },
    {  "March", 2011  },
    {  "April", 2011  },
    {  "May", 2011  },
    {  "June", 2011  },
    {  "July", 2011  },
    {  "August", 2011  },
    {  "September", 2011  },
    {  "October", 2011  },
    {  "November", 2011  },
}

The month names being dependent on your culture which, I think, is exactly what you asked for, right?

Answer 2

You can start off with a while loop where the start date is less than or equal to the end date

Within it pull out the relevant Month and year part from the start date and store them (maybe you have a concrete class or a as a ), then increment the start date by 1 month using AddMonths(1)

//something on these lines 
while(startdate <= enddate)
{
// pull out month and year
startdate = startdate.AddMonths(1);
}

Answer 3

You can use Enumerable.Range function to get the month and year between two dates,

var start = new DateTime(2011, 1, 1);
var end = new DateTime(2011, 11, 30);

var diff = Enumerable.Range(0, 13).Select(a => start.AddMonths(a))
           .TakeWhile(a => a <= end)
           .Select(a => String.Concat(a.ToString("MMMM") + ", " + a.Year));

Answer 4

Use this formula :

((date1.Year - date2.Year) * 12) + date1.Month - date2.Month

And u get the number of months .

Use this in an appropriate way and you will crack it.

Welcome to Stackoverflow , Here Hardwork is your part and giving thinking lines for that is for the fraternity to do when you have a problem.

Answer 5

for(DateTime date = fromDate; date <= toDate; date.AddMonths(1))
{
    //Do something with "date"
    //DateTime.ParseExact(date, "MM/dd/yyyy")
}

Answer 6

This function return list of months between two dates

public static IEnumerable<dynamic> MonthsBetween(
    DateTime startDate,
    DateTime endDate)
{
    DateTime iterator;
    DateTime limit;

    if (endDate > startDate)
    {
        iterator = new DateTime(startDate.Year, startDate.Month, 1);
        limit = endDate;
    }
    else
    {
        iterator = new DateTime(endDate.Year, endDate.Month, 1);
        limit = startDate;
    }

    var dateTimeFormat = CultureInfo.CurrentCulture.DateTimeFormat;
    while (iterator <= limit)
    {
        
        var firstDayOfMonth = new DateTime(iterator.Year, iterator.Month, 1);
        var lastDayOfMonth = firstDayOfMonth.AddMonths(1).AddDays(-1);

        yield return new {
            Label = dateTimeFormat.GetMonthName(iterator.Month),
            Code = iterator.Year+"-"+iterator.Month,
            FirstDay = firstDayOfMonth,
            LastDay = lastDayOfMonth
        };

        iterator = iterator.AddMonths(1);
    }
}

Answer 7

private HashSet<string> GetMonths(DateTime start, DateTime end)
    {
        var totalMonths = ((end.Year - start.Year) * 12) + (end.Month - start.Month) + 1;
        var diff = Enumerable.Range(0, totalMonths).Select(a => start.AddMonths(a))
                   .TakeWhile(a => a <= end)
                   .Select(a => a.ToString("MMM")).ToHashSet();

        return diff;
    }

Answer 8

        List<string> month= new List<string>();
        while (startDateValue <= endDateValue)
        {
            
            month.AddRange(new List<string>{ startDateValue.ToString("MMMM") }); 
            startDateValue = startDateValue.AddMonths(1); 
        }

Answer 9

You can utilize Linq by employing Enumerable.Range(startIndex, endIndex).
Example below:

    private string[] GetMonthsBetweenDates(DateTime deltaDate, int TotalMonths)
{
    var monthsBetweenDates = Enumerable.Range(0, TotalMonths)
                                       .Select(i => deltaDate.AddMonths(i))
                                       .OrderBy(e => e)
                                       .AsEnumerable();

    return monthsBetweenDates.Select(e => e.ToString("MMM")).ToArray();
}

The code above should produce the following results, assuming the current month is November.

Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct