Get dateformat in yyyymm

[Agnes]

If my input date is 2004-02-05, I want to get '200402'
Can anyone know the simple way to do ? Thanks a lot
--
..

[Scott Swigart]

Dim d As DateTime = "2004-02-05"

MessageBox.Show(d.Year.ToString("0000") & d.Month.ToString("00"))


--
Scott Swigart
http://blog.swigartconsulting.com

"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:e2****************@tk2msftngp13.phx.gbl...

If my input date is 2004-02-05, I want to get '200402'
Can anyone know the simple way to do ? Thanks a lot
--
.

[Herfried K. Wagner [MVP]]

"Agnes" <ag***@dynamictech.com.hk> schrieb:

If my input date is 2004-02-05, I want to get '200402'
Can anyone know the simple way to do ? Thanks a lot

\\\
MsgBox( _
Date.ParseExact( _
"2004-02-05", _
"yyyy-MM-dd", _
Nothing _
).ToString("yyyyMM") _
)
///

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[Cor Ligthert]

Agnes

MyResultString = MyOriginalString.substring(0,4) &
MyOriginalString.substring(5,2)

I hope this helps?

Cor

"Agnes"

If my input date is 2004-02-05, I want to get '200402'
Can anyone know the simple way to do ? Thanks a lot
--
.

[Oenone]

Agnes wrote:

If my input date is 2004-02-05, I want to get '200402'
Can anyone know the simple way to do ? Thanks a lot

To add another possible solution:

Dim d As DateTime = DateTime.Parse("2004-02-05")
MessageBox.Show(Format(d, "yyyyMM"))

--

(O)enone

[Phill. W]

"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:e2****************@tk2msftngp13.phx.gbl...

If my input date is 2004-02-05, I want to get '200402'
Can anyone know the simple way to do ? Thanks a lot

Dim dtThen as DateTime _
= CDate( "2004-02-05" )

Console.Writeline( dtThen.ToString("yyyyMM") )
' NB: That's "MM", not "mm"

HTH,
Phill W.