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"))

 

[Herfried K. Wagner [MVP]]

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") _
)
///

 

[Cor Ligthert]

Agnes

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

I hope this helps?

Cor

"Agnes"

 

[Oenone]

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"))

 

[Phill. W]

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.