Set Textbox value to last month

Question

How do i set the textbox value to last day of last month(to end of previous month), using today's date.

for example:

if today is 23/03/2012 textbox value should be 29/02/2012 if come next month and date is 12/04/2012 then textbox value should be 31/03/2012 and so on

Thanks

possible duplicate of [Get the previous month's first and last day dates in c#](http://stackoverflow.com/questions/591752/get-the-previous-months-first-and-last-day-dates-in-c-sharp) — itsmatt, Mar 23 '12 at 12:47
Ha... got 4 duplicates just inside this question. Take your pick. — Chris Gessler, Mar 23 '12 at 12:52

score 2 · Accepted Answer · answered Mar 23 '12 at 12:47

2

Take the first day of the current month and subtract 1:

DateTime value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).AddDays(-1);

answered Mar 23 '12 at 12:47

mgnoonan

6,962
5
23
27

score 1 · Answer 2 · answered Mar 23 '12 at 12:48

1

DateTime date = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).AddDays(-1);
textBox1.Text = date.ToShortDateString();

answered Mar 23 '12 at 12:48

ionden

12,216
1
43
37

score 0 · Answer 3 · answered Mar 23 '12 at 12:47

0

Use DateTime.DaysInMonth to accomplish this:

var daysInMonth = DateTime.DaysInMonth(dt.Year, dt.Month - 1);
var lastDayInMonth = new DateTime(dt.Year, dt.Month - 1, daysInMonth);
textBox1.Text = lastDayInMonth.ToString("dd/MM/yyyy");

answered Mar 23 '12 at 12:47

David Morton

15,960
2
61
72

daryal · Answer 4 · 2012-03-23T12:55:48.357

0

Get the first day of the month and subtract one day.

DateTime lastDayOfThePreviousMonth = dateSelected.AddDays(-dateSelected.Day);

edited Mar 23 '12 at 12:55

answered Mar 23 '12 at 12:48

daryal

14,403
4
36
54

Curious.. What if the current day is 1? Would it then Add -0 days? – Chris Gessler Mar 23 '12 at 12:51
@ChrisGessler you are right, no need to subtract one from the days. I have updated. – daryal Mar 23 '12 at 12:56

score 0 · Answer 5 · answered Mar 23 '12 at 12:48

0

In C#:

DateTime dt = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1).AddDays(-1);

Then call .ToString() and pass in whatever format you like.

answered Mar 23 '12 at 12:48

Chris Gessler

22,017
6
53
80

Set Textbox value to last month

5 Answers5