How to get the last date of the month?

[Alpha]

Hi, I have a datetime variable. How can I get the date for the end of the
month according to that varilable's month and year?

Thanks,
Alpha

[William Stacey [MVP]]

DateTime dt = DateTime.Now;

DateTime firstDayOfThisMonth = dt.Subtract(TimeSpan.FromDays(dt.Day - 1));

Console.WriteLine("First Day of This Month:" + firstDayOfThisMonth);

DateTime firstDayOfNextMonth = firstDayOfThisMonth.AddMonths(1);

Console.WriteLine("First Day of next month" +
firstDayOfNextMonth.ToString());

DateTime lastDayOfThisMonth =
firstDayOfNextMonth.Subtract(TimeSpan.FromDays(1)) ;

Console.WriteLine("Last day of this month:"+lastDayOfThisMonth.ToString());
--
William Stacey [MVP]

"Alpha" <Al***@discussions.microsoft.com> wrote in message
news:6A**********************************@microsof t.com...

Hi, I have a datetime variable. How can I get the date for the end of the
month according to that varilable's month and year?

Thanks,
Alpha

[Mark Rae]

"Alpha" <Al***@discussions.microsoft.com> wrote in message
news:6A**********************************@microsof t.com...

Hi, I have a datetime variable. How can I get the date for the end of the
month according to that varilable's month and year?

private DateTime LastDayOfMonth(DateTime pdtmDate)
{
DateTime dtmDate = new DateTime(pdtmDate.Year, pdtmDate.Month, 1);
return dtmDate.AddMonths(1).AddDays(-1);
}

[John B]

Alpha wrote:

Hi, I have a datetime variable. How can I get the date for the end of the
month according to that varilable's month and year?

Thanks,
Alpha

DateTime d = new DateTime(Year, Month, DateTime.DaysInMonth(Year, Month));

[Alpha]

Thanks for everyone's help and it's working.
Alpha

"Mark Rae" wrote:

"Alpha" <Al***@discussions.microsoft.com> wrote in message
news:6A**********************************@microsof t.com...

Hi, I have a datetime variable. How can I get the date for the end of the
month according to that varilable's month and year?

private DateTime LastDayOfMonth(DateTime pdtmDate)
{
DateTime dtmDate = new DateTime(pdtmDate.Year, pdtmDate.Month, 1);
return dtmDate.AddMonths(1).AddDays(-1);
}