End of month calculations

vdh_ant picture vdh_ant · Jun 11, 2009 · Viewed 10.6k times · Source

Just wondering if any know of an elegant solution for the following.

If I have 30 June 2009 and I add a month I want it to go to 31 July 2009, not the 30 July 2009.

This logic is based on the fact that the 30 June 2009 was the end of the month of June and when I add a month I want to go to the end of the next month.

But if I have 29 June 2009 and I add a month it should go to 29 July 2009.

Note I need to be able to add any number of months and I need to take into account leap years.

Also I know the logic here is questionable but it is a business requirement that works with end of month contracts going to the end of the month for a month in the future.

I have thought of several solution but none that are very elegant. Hence I was thinking someone might have a better way.

Cheers Anthony

Answer

Jimmy picture Jimmy · Jun 11, 2009

To check if a date is the end of the month, you check if the next day is day one of some month. your algorithm should then be "If the day is not end of month, add 1 month. If it is the end of the month, add one day, add one month, subtract one day."

    bool IsEndOfMonth(DateTime date) {
        return date.AddDays(1).Day == 1;
    }
    DateTime AddMonthSpecial(DateTime date) {
        if (IsEndOfMonth(date))
            return date.AddDays(1).AddMonths(1).AddDays(-1);
        else
            return date.AddMonths(1);
    }