formatDate Method

Formats the supplied date using the specified formatting options.

Syntax

strValue = oXTLRuntime.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, uses the sequence month-day-year.

Returns

String. Returns the string containing the date in the requested format.

Applies To

IXTLRuntime

Does this content meet your programming needs? Write us!

Back to top