CODEWITHSUNDEEP
asp.netvb.netdatesubtraction
Andrew
Andrew

Reputation: 11318

How to subtract a month from Date object?

How do I subtract a month from a date object in VB.NET?

I have tried:

Today.AddMonths(-1)

However, given that Today is 01-Jan-2010, the result I get is 01-Dec-2010. The answer I want is 01-Dec-2009.

Is there a convenient way of doing this within the .NET framework?

Upvotes: 26

Views: 60271

Answers (4)

dbasnett
dbasnett

Reputation: 11773

Dim d As DateTime = #1/1/2010#
d = d.AddMonths(-1)

Upvotes: 2

ksk
ksk

Reputation: 311

I have used the following and it works.

Dim dtToday As DateTime = Date.Today
dtToday = dtToday.AddMonths(-2)

Upvotes: 1

Adriaan Stander
Adriaan Stander

Reputation: 166346

This works fine, you need to remember that the DateTime is imutable.

Dim d As DateTime
d = New DateTime(2010, 1, 1)
d = d.AddMonths(-1)

Have a look at DateTime Structure

A calculation on an instance of DateTime, such as Add or Subtract, does not modify the value of the instance. Instead, the calculation returns a new instance of DateTime whose value is the result of the calculation.

Upvotes: 8

Joel Etherton
Joel Etherton

Reputation: 37533

You actually have to transport Today into a variable and let that assignment work there. The following code will produce the result you expect (I just verified it because your post made me think twice).

Dim dt As DateTime = Date.Today
dt = dt.AddMonths(-2)

Dim x As String = dt.ToString()

Upvotes: 44

Related Questions