FormatDateTime Procedure |
Version 6 |
Returns a string that contains the formatted DateTime value.
bsDate = FormatDateTime ( dt, [bsFormat] )
The FormatDateTime procedure syntax has the following parts:
|
Name |
Type |
Description |
|
dt |
DateTime |
date time to be formatted |
|
bsFormat |
Val BString |
A formatting string - see below for default format and formatting codes - the formatting codes are preceded by a percent sign (%). |
|
bsDate |
Val BString |
A string that contains the formatted date/time value |
Using the default format parameter, this will print the date and the time, unless the time portion is 0 (midnight), in which case it will print just the date, or the date portion is 0 (30 December 1899), in which case it will print just the time. If the date/time value is 0 (30 December 1899, midnight), this form with the default parameters will print midnight.
The value and meaning of the formatting codes for Format are listed below:
|
Code |
Description |
|
%a |
Abbreviated weekday name |
|
%A |
Full weekday name |
|
%b |
Abbreviated month name |
|
%B |
Full month name |
|
%c |
Date and time representation appropriate for locale |
|
%d |
Day of month as decimal number (01 – 31) |
|
%H |
Hour in 24-hour format (00 – 23) |
|
%I |
Hour in 12-hour format (01 – 12) |
|
%j |
Day of year as decimal number (001 – 366) |
|
%m |
Month as decimal number (01 – 12) |
|
%M |
Minute as decimal number (00 – 59) |
|
%p |
Current locale’s A.M./P.M. indicator for 12-hour clock |
|
%S |
Second as decimal number (00 – 59) |
|
%U |
Week of year as decimal number, with Sunday as first day of week (00 – 53) |
|
%w |
Weekday as decimal number (0 – 6; Sunday is 0) |
|
%W |
Week of year as decimal number, with Monday as first day of week (00 – 53) |
|
%x |
Date representation for current locale |
|
%X |
Time representation for current locale |
|
%y |
Year without century, as decimal number (00 – 99) |
|
%Y |
Year with century, as decimal number |
|
%z, %Z |
Time-zone name or abbreviation; no characters if time zone is unknown |
|
%% |
Percent sign |
The following will display date as in Windows Explorer:
sDate=FormatDateTime(stStatus.dtLastModified, "%m/%d/%Y %I:%M %p")