Formats the supplied date using the specified formatting options.
Syntax
formatDate(varDate, bstrFormat, varDestLocale)
Parameters
varDate
Variant. Date that is to be formatted.
bstrFormat
String. Specified formatting. The following codes are supported:
| m | Months as 1-12 |
| mm | Months as 01-12 |
| mmm | Months as Jan-Dec |
| mmmm | Months as January-December |
| mmmmm | Months as the first letter of the month |
| d | Days as 1-31 |
| dd | Days as 01-31 |
| ddd | Days as Sun-Sat |
| dddd | Days as Sunday-Saturday |
| yy | Years as 00-99 |
| yyyy | Years as 1900-9999 |
varDestLocale
Variant. Locale to use in determining the correct sequence to be used in the date. If not supplied, the month-day-year sequence is used.
Returns
String. Returns the string containing the date in the requested format.
Applies To