.net - primer - ultimo dia del mes

¿Cómo determinar el último día hábil en un mes determinado?

Question

¿Cómo puedo calcular el último día hábil del mes en .NET?

Answer 1

Primero, obtenga el último día del mes. Luego continúe decreciendo hasta que haya pasado el comienzo del mes o haya alcanzado una fecha que valide como un "día hábil".

Answer 2

Suponiendo que los días hábiles sean de lunes a viernes (esto no incluye vacaciones), esta función debe devolver la respuesta correcta:

Function GetLastBusinessDay(ByVal Year As Integer, ByVal Month As Integer) As DateTime
    Dim LastOfMonth As DateTime
    Dim LastBusinessDay As DateTime

    LastOfMonth = New DateTime(Year, Month, DateTime.DaysInMonth(Year, Month))

    If LastOfMonth.DayOfWeek = DayOfWeek.Sunday Then 
        LastBusinessDay = LastOfMonth.AddDays(-2)
    ElseIf LastOfMonth.DayOfWeek = DayOfWeek.Saturday Then
        LastBusinessDay = LastOfMonth.AddDays(-1)
    Else
        LastBusinessDay = LastOfMonth
    End If

    Return LastBusinessDay

End Function

Answer 3

propósito general, pseudocódigo:

Day day = getLastDayOfMonth
int days = getDaysInMonth
for i = days to 0
  if day is weekday
    if day is not holiday
      return day
    end if
  end if
  day = prevDay
  days--
end for

throw exception because no business day was found in the month

Answer 4

Function GetLastDay(ByVal month As Int32, ByVal year As Int32) As Date
        Dim D As New Date(year, month, Date.DaysInMonth(year, month))
        For i As Integer = 0 To Date.DaysInMonth(year, month)
            Select Case D.AddDays(-i).DayOfWeek
                Case DayOfWeek.Saturday, DayOfWeek.Sunday ''Not a weekday
                Case Else  ''Is a weekday.  Flag as first weekday found
                    Return D.AddDays(-i)
                    ''you can add other code here which could also do a check for holidays or ther stuff since you have a proper date value to look at in the loop
            End Select
        Next
End Function

Answer 5

Podría pensar en este simple código de C # que le da el último día hábil del mes actual. Esto solo toma el sábado o el domingo como días festivos. Las vacaciones locales específicas del país deben manejarse de forma manual.

private DateTime GetLastBusinessDayOfCurrentMonth()
{
    var lastDayOfCurrentMonth = new DateTime(DateTime.Now.Year, DateTime.Now.Month,  DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month));

    if(lastDayOfCurrentMonth.DayOfWeek == DayOfWeek.Sunday)
        lastDayOfCurrentMonth = lastDayOfCurrentMonth.AddDays(-2);
    else if(lastDayOfCurrentMonth.DayOfWeek == DayOfWeek.Saturday)
        lastDayOfCurrentMonth = lastDayOfCurrentMonth.AddDays(-1);

    return lastDayOfCurrentMonth;
}

Answer 6

Lo haría así durante la semana laboral de lunes a viernes:

var holidays = new List<DateTime>{/* list of observed holidays */};
DateTime lastBusinessDay = new DateTime();
var i = DateTime.DaysInMonth(year, month);
while (i > 0)
{
  var dtCurrent = new DateTime(year, month, i);
  if(dtCurrent.DayOfWeek < DayOfWeek.Saturday && dtCurrent.DayOfWeek > DayOfWeek.Sunday && 
   !holidays.Contains(dtCurrent))
    {
      lastBusinessDay = dtCurrent;
      i = 0;
    }
    else
    {
      i = i - 1;
    }
}

Answer 7

Se me ocurrió un método adicional que se puede utilizar para obtener el día hábil anterior o actual más cercano que luego se puede usar para obtener el último día hábil del mes; esto también se tiene en cuenta si se está ajustando para las vacaciones de fin de semana:

public static DateTime LastBusinessDayInMonth(int year, int month, bool adjustForWeekend = true)
{
    var lastDay = DateTime.DaysInMonth(year, month);
    return PreviousOrCurrentBusinessDay(new DateTime(year, month, lastDay), adjustForWeekend);
}

public static DateTime PreviousOrCurrentBusinessDay(DateTime? beforeOrOnDate = null, bool adjustForWeekend = true)
{
    var fromDate = beforeOrOnDate ?? DateTime.Today;
    var year = fromDate.Year;
    var month = fromDate.Month;
    var day = fromDate.Day;
    var holidays = UsHolidays(fromDate.Year, true).ToList(); // defined below
    var dtCurrent = new DateTime(year, month, day);

    while (!(dtCurrent.DayOfWeek < DayOfWeek.Saturday && dtCurrent.DayOfWeek > DayOfWeek.Sunday && !holidays.Contains(dtCurrent)))
    {
        dtCurrent = dtCurrent.AddDays(-1);
    }
    return dtCurrent;
}

También utilizo las vacaciones de EE. UU. En mi cálculo que obtengo del siguiente código que desarrollé al mirar esta publicación: http://geekswithblogs.net/wpeck/archive/2011/12/27/us-holiday-list-in- c.aspx

El código se puede ver aquí para eso:

public static IEnumerable<DateTime> UsHolidays(int year, bool adjustForWeekend)
{
    return new List<DateTime>()
    {
        NewYears(year, adjustForWeekend),
        MlkDay(year),
        PresidentsDay(year),
        GoodFriday(year),
        MemorialDay(year),
        IndependenceDay(year, adjustForWeekend),
        LaborDay(year),
        Thanksgiving(year),
        Christmas(year, adjustForWeekend),
    };
}

public static DateTime NewYears(int year, bool adjustForWeekend)
{
    //NEW YEARS 
    return adjustForWeekend ? AdjustForWeekendHoliday(new DateTime(year, 1, 1).Date) : new DateTime(year, 1, 1).Date;
}

public static DateTime MemorialDay(int year)
{
    //MEMORIAL DAY  -- last monday in May 
    var memorialDay = new DateTime(year, 5, 31);
    var dayOfWeek = memorialDay.DayOfWeek;
    while (dayOfWeek != DayOfWeek.Monday)
    {
        memorialDay = memorialDay.AddDays(-1);
        dayOfWeek = memorialDay.DayOfWeek;
    }
    return memorialDay.Date;
}

public static DateTime IndependenceDay(int year, bool adjustForWeekend)
{
    //INDEPENCENCE DAY 
    return adjustForWeekend ? AdjustForWeekendHoliday(new DateTime(year, 7, 4).Date) : new DateTime(year, 7, 4).Date;
}

public static DateTime LaborDay(int year)
{
    //LABOR DAY -- 1st Monday in September 
    var laborDay = new DateTime(year, 9, 1);
    var dayOfWeek = laborDay.DayOfWeek;
    while (dayOfWeek != DayOfWeek.Monday)
    {
        laborDay = laborDay.AddDays(1);
        dayOfWeek = laborDay.DayOfWeek;
    }
    return laborDay.Date;
}

public static DateTime Thanksgiving(int year)
{
    //THANKSGIVING DAY - 4th Thursday in November 
    var thanksgiving = (from day in Enumerable.Range(1, 30)
                        where new DateTime(year, 11, day).DayOfWeek == DayOfWeek.Thursday
                        select day).ElementAt(3);
    var thanksgivingDay = new DateTime(year, 11, thanksgiving);
    return thanksgivingDay.Date;
}

public static DateTime Christmas(int year, bool adjustForWeekend)
{
    return adjustForWeekend ? AdjustForWeekendHoliday(new DateTime(year, 12, 25).Date) : new DateTime(year, 12, 25).Date;
}

public static DateTime MlkDay(int year)
{
    //Martin Luther King Day -- third monday in January
    var MLKDay = new DateTime(year, 1, 21);
    var dayOfWeek = MLKDay.DayOfWeek;
    while (dayOfWeek != DayOfWeek.Monday)
    {
        MLKDay = MLKDay.AddDays(-1);
        dayOfWeek = MLKDay.DayOfWeek;
    }
    return MLKDay.Date;
}

public static DateTime PresidentsDay(int year)
{
    //President''s Day -- third monday in February
    var presDay = new DateTime(year, 2, 21);
    var dayOfWeek = presDay.DayOfWeek;
    while (dayOfWeek != DayOfWeek.Monday)
    {
        presDay = presDay.AddDays(-1);
        dayOfWeek = presDay.DayOfWeek;
    }
    return presDay.Date;
}

public static DateTime EasterSunday(int year)
{
    var g = year % 19;
    var c = year / 100;
    var h = (c - c / 4 - (8 * c + 13) / 25 + 19 * g + 15) % 30;
    var i = h - h / 28 * (1 - h / 28 * (29 / (h + 1)) * ((21 - g) / 11));

    var day = i - ((year + year / 4 + i + 2 - c + c / 4) % 7) + 28;
    var month = 3;

    if (day > 31)
    {
        month++;
        day -= 31;
    }

    return new DateTime(year, month, day);
}

public static DateTime GoodFriday(int year)
{
    return EasterSunday(year).AddDays(-2);
}

public static DateTime AdjustForWeekendHoliday(DateTime holiday)
{
    if (holiday.DayOfWeek == DayOfWeek.Saturday)
    {
        return holiday.AddDays(-1);
    }
    return holiday.DayOfWeek == DayOfWeek.Sunday ? holiday.AddDays(1) : holiday;
}

Answer 8

Usando LINQ:

   public static DateTime GetLastBussinessDayCurrentMonth(DateTime[] holidays)
   {
        DateTime todayDateTime = DateTime.Today;

        return
            Enumerable.Range(1, DateTime.DaysInMonth(todayDateTime.Year, todayDateTime.Month))
                .Select(day => new DateTime(todayDateTime.Year, todayDateTime.Month, day))
                .Where(
                    dt =>
                    dt.DayOfWeek != DayOfWeek.Sunday && dt.DayOfWeek != DayOfWeek.Saturday
                    && (holidays == null || !holidays.Any(h => h.Equals(dt))))
                .Max(d => d.Date);
   }

Explicando

Crear una lista de enteros con todos los días disponibles en el mes

      Enumerable.Range(1, DateTime.DaysInMonth(todayDateTime.Year, todayDateTime.Month))

Filtrando solo días que no caen los fines de semana y no caen en vacaciones

            .Where(
                dt =>
                dt.DayOfWeek != DayOfWeek.Sunday && dt.DayOfWeek != DayOfWeek.Saturday
                && (holidays == null || !holidays.Any(h => h.Equals(dt))))

Crear nueva fecha y hora con las fechas filtradas

            .Select(day => new DateTime(todayDateTime.Year, todayDateTime.Month, day))

            .Max(d => d.Date);

Answer 9

Aquí es cómo encontrar el último día del mes en C #:

DateTime today = DateTime.Today;
DateTime endOfMonth = new DateTime(today.Year,
                                   today.Month,
                                   DateTime.DaysInMonth(today.Year,
                                   today.Month));

Fuente