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 |
Optional. A formatting string - see below for format formatting codes - the formatting codes are preceded by a percent sign (%). |
bsDate |
Val BString |
A string that contains the formatted date/time value |
Omitting the bsFormat parameter will cause the function to use the Windows system format specifications as set using the Windows Control Panel.
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 print the current date and time in the "Date=Nov
06, 2006; Time=01:55 PM" format:
ParseDateTime(SDate()+" "+STime(), dt)
print FormatDateTime(dt, "Date=%b %d, %Y; Time=%I:%M %p")