I am getting date as April,1,2009. I want to format the date so that the month is displayed as 4. Not only for the date given above but for whatever date is given. Can anybody give appropriate code?
Use the ToShortDateString function of the DateTime DataType to get the String representation of a Date in the format you specified.
date.ToShortDateString()
Here's the link to the MSDN documentation. There are a number of predefined ToString functions for the DateTime DataType to make formatting for display easier. The link also explains the Culture sensitivity of the Function.
To get just the month as an integer, you could use this.
Dim inputDate As String = "April 1, 2009"
Dim outputDate As Date = Date.Parse(inputDate)
Dim month As Integer = outputDate.Month
Of course you'll want to make sure inputDate is valid. For that you can use DateTime.TryParse instead of DateTime.Parse.
As well as thedate.Month, thedate.ToString("format string") works well. "MM" for month, and it can be combined in as you please.
I would also suggest using .ToString() if you are intending using the whole date after converting the month to an int
Dim strDate As String = "April,1,2009"
Dim [date] As DateTime = DateTime.Parse(strDate)
Dim sDate As String = [date].ToString("M,d,yyyy")
sorry if the format is weird, but I am C# developer and used an online converter.