FormatDateTime Function |
Microsoft.VisualBasic.Strings
FormatDateTime( expression [, dateformat ])
Date variable or literal date
Defines the format of the date to return
String representing the formatted date or time
Formats a date or time expression based on the computer's regional settings
The Dateformat enum is:
Displays a date and/or time. If there is a date part, displays it as a short date. If there is a time part, displays it as a long time. If present, both parts are displayed.
Uses the long-date format specified in the client computer's regional settings.
Uses the short-date format specified in the client computer's regional settings.
Uses the time format specified in the computer's regional settings.
Uses a 24- hour format (hh:mm).
The default date format is GeneralDate .
Remember that date and time formats obtained from the client computer are based upon the client computer's regional settings. It is not uncommon for a single application to be used internationally, so date formats can vary widely. Not only that, but you can never be sure that a user has not modified the regional settings on her computer. In short, never take a date coming in from a client machine for granted; ideally , you should always verify that it is in the format you need prior to using it.
There is no appreciable difference in either coding or performance between these two statements:
sDate = FormatDateTime(dDate, LongDate) sDate = Format(dDate, "Long Date")
Format Function, FormatCurrency, FormatNumber, FormatPercent Functions