Get specific dates

Question

I am working with dates in C# and need to calculate some further dates. Taking the current datetime.

How can I get the following values?

end of day
end of month
end of year

What do you mean by end of day? Do you mean end of business day like 5PM or 11.59 PM? — unlimit, Jun 16 '13 at 12:08

score 9 · Accepted Answer · edited Jun 16 '13 at 12:33

9

If by end of ... you mean 12:59:59.999PM at that day then:

end of day

var today = DateTime.Today;
var endOfDay = new DateTime(
    today.Year, 
    today.Month,
    today.Day,
    23,
    59,
    59,
    999
);

end of month

var today = DateTime.Today;
var endOfMonth = new DateTime(
    today.Year, 
    today.Month,
    DateTime.DaysInMonth(today.Year, today.Month),
    23,
    59,
    59,
    999
);

end of year

var today = DateTime.Today;
var endOfYear = new DateTime(
    today.Year,
    12,
    31,
    23,
    59,
    59,
    999
);

If you mean something else, then explain what you mean.

edited Jun 16 '13 at 12:33

Tim S.

55,448
7
96
122

answered Jun 16 '13 at 12:07

Darin Dimitrov

1,023,142
271
3,287
2,928

It should be 11:59 of course. Thanks for pointing that out. I have updated my answer. – Darin Dimitrov Jun 16 '13 at 12:16

score 3 · Answer 2 · edited May 23 '17 at 12:29

For end of month

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

see How can I get the last day of the month in C#?

For end of year

DateTime endOfYear = new DateTime(today.Year, 12, 31);

For end of day, assuming the end of day is close of business at 5 PM

DateTime endOfDay = new DateTime(today.Year, today.Month, today.day, 17, 0, 0); // Assuming the business end of day is at 5 PM

See more about datetime at http://msdn.microsoft.com/en-us/library/system.datetime.aspx

score 0 · Answer 3 · answered Jun 16 '13 at 12:07

Last day of month:

DateTime today = DateTime.Now;
DateTime lastDayOfMonth = new DateTime(today.Year, today.Month, DateTime.DaysInMonth(today.Year, today.Month));

Last day of year:

DateTime today = DateTime.Now;
DateTime lastDayOfYear = new DateTime(today.Year, 12, 31);

Get specific dates

3 Answers3