Is there any way I can convert a date of format: dd/mm/yyyy to yyyymmdd format? For开发者_Go百科 example from : 25/07/2011 to 20110725? in VB.NET?
Dates themselves don't have formats inherently. You can parse a string into a DateTime
by parsing it with dd/MM/yyyy
format and then convert that into a string using yyyyMMdd
format:
DateTime date = DateTime.ParseExact(text, "dd/MM/yyyy",
CultureInfo.InvariantCulture);
string reformatted = date.ToString("yyyyMMdd", CultureInfo.InvariantCulture);
Or in VB:
Dim date as DateTime = DateTime.ParseExact(text, "dd/MM/yyyy", CultureInfo.InvariantCulture)
Dim reformatted as String = date.ToString("yyyyMMdd", CultureInfo.InvariantCulture)
(And make sure you have an import for System.Globalization
.)
However, ideally you should keep it as a DateTime
(or similar) for as long as possible.
CDate(Datetext).ToString("yyyyMMdd")
Use the DateTime.ParseExact
method to parse the date, then use DateTimeObj.ToString("yyyyMMdd")
.
DaTeTime.ParseExact
Public Function DateFormateYYYYMMDD(ByVal Dtp As DateTimePicker) As String
Try
Dim StrDate, StrYear, StrMonth, StrDay As String
StrDate = FormatDateTime(Dtp.Value, DateFormat.ShortDate)
StrMonth = Month(Dtp.Value)
StrDay = Convert.ToString(Dtp.Value.Day)
StrYear = Year(Dtp.Value)
StrDate = StrYear + "-" + StrMonth + "-" + StrDay
Return StrDate
Catch ex As Exception
End Try
End Function
this function can be used to convert datetime picker value format to yyyyMMdd
精彩评论