Get yesterday date

[Li Pang]

Hi,

In VB6 I used Now() -1 to get yesterday, but it's not allowed in vb.NET. Is
there a similar way to do it in vb.Net?

Thanks in advance

[Li Pang]

May be work with
Now().AddDays(-1)

"Li Pang" wrote:

Hi,

In VB6 I used Now() -1 to get yesterday, but it's not allowed in vb.NET. Is
there a similar way to do it in vb.Net?

Thanks in advance

[Juan Pedro Gonzalez]

Hi Li Pang,

You can use the following code:

Dim oTimeSpan As New System.TimeSpan(1,0,0,0)
Dim oDate As System.DateTime = System.DateTime.Now.Substract(oTimeSpan)

and oDate should contain yesterdays date...

Greetings,

Juan Pedro Gonzalez


"Li Pang" <Li****@discussions.microsoft.com> escribió en el mensaje
news:96**********************************@microsof t.com...

Hi,

In VB6 I used Now() -1 to get yesterday, but it's not allowed in vb.NET. Is there a similar way to do it in vb.Net?

Thanks in advance

[Cor Ligthert]

Li Pang,

You mean this?
Dim yesterday As DateTime = Now.AddDays(-1)

I hope this helps,

Cor

[Larry Lard]

Li Pang wrote:

Hi,

In VB6 I used Now() -1 to get yesterday, but it's not allowed in vb.NET. Is
there a similar way to do it in vb.Net?

Thanks in advance

As others have posted, Now.AddDays(-1) is the literal translation of
the VB6 expression Now() - 1.

But if you want *yesterday*, rather than *this time yesterday*, you
should be using Today, not Now.

--
Larry Lard
Replies to group please