|Important||This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer|
FormatDateTime Function (Visual Basic)
Returns a string expression representing a date/time value.
Function FormatDateTime( ByVal Expression As DateTime, Optional ByVal NamedFormat As DateFormat = DateFormat.GeneralDate ) As String
Required. Date expression to be formatted.
Optional. Numeric value that indicates the date/time format used. If omitted, DateFormat.GeneralDate is used.
The NamedFormat argument has the following settings.
Display a date and/or time. Display a date part as a short date. If there is a time part, display it as a long time. If present, both parts display.
Display a date using the long date format specified in your computer's regional settings.
Display a date using the short date format specified in your computer's regional settings.
Display a time using the time format specified in your computer's regional settings.
Display a time using the 24-hour format (hh:mm).
|Exception type||Error number||Condition|
NamedFormat setting is not valid.
See the "Error number" column if you are upgrading Visual Basic 6.0 applications that use unstructured error handling. (You can compare the error number against the.) However, when possible, you should consider replacing such error control with .
The Date data type always contains both date and time information. For purposes of type conversion, Visual Basic considers 1/1/1 (January 1 of the year 1) to be a neutral value for the date, and 00:00:00 (midnight) to be a neutral value for the time. If you format a Date value as a date/time string, FormatDateTime does not include neutral values in the resulting string. For example, if you convert #1/1/0001 9:30:00# to a string, the result is "9:30:00 AM"; the date information is suppressed. However, the date information is still present in the original Date value and can be recovered with functions such as DatePart.
If you pass the Expression argument as a String literal, FormatDateTime interprets it according to the setting of your application. However, if you pass it as a Date literal, use the format #mm/dd/yyyy#, because FormatDateTime always interprets a Date literal according to the English (US) culture. This is necessary because, if an application is developed and coded using Date literals from one culture, but is then executed on a platform with a different culture, the Date literals could be parsed incorrectly.
This example demonstrates the use of the FormatDateTime function.
Assembly: Visual Basic Runtime Library (in Microsoft.VisualBasic.dll)