adding months to get last day of month

WannaBeVb · June 28th, 2010, 10:04 PM

I need to add months and get the last day of the month. Rigth now i pass a variable whihc is my last value in my gridview which is a date called lastdate
so I need to add to last date to find the last day of the next month to populate it with my datagrid. Here is some code but doe not work right what am I doing wrong.

Newdt = DateAdd(DateInterval.Month, (Day(DateAdd(DateInterval.Month, 1, lastdate))) * -1, DateAdd(DateInterval.Month, 1, Newdt))

samjudson · June 29th, 2010, 05:44 AM

This is a .Net forum, yet you appear to be using the old VB style methods. These are in the compatibility layer, but things are usually much easier if you use the newer 'pure' .Net classes.

The following will give you the last day of the current month stored in newdt variable:

Code:

Newdt = new DateTime(Newdt.Year, Newdt.Month, 1).AddMonths(1).AddDays(-1)

WannaBeVb · June 29th, 2010, 09:55 AM

Thanks for the reply, I grabbed the code off the interweb and did not know what version it was other than it was not pulling the correct info.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Finding last day of a month	John Anthony	Access VBA	9	October 6th, 2008 03:27 PM
get year,month,day,hour...	kobystud	C#	1	July 16th, 2004 04:45 PM
Asp day of month display	karib	Classic ASP Databases	10	April 5th, 2004 12:56 AM
1st Week-Day of the Month	ticktack	Classic ASP Basics	2	January 19th, 2004 10:01 AM