Date And Time
|
| Tips >> Visual
Basic |
|
The basic data type "Date" is used in Visual Basic
to store the "date and time". Date literals are enclosed
within the # operator.
|
Dim birthDate As Date
birthDate = #1/20/1964# |
|
|
THE FORMAT FUNCTION:
The Format function is used to format dates and numbers.
The actual result is dependent on the country settings on the computer.
The general syntax is:
|
|
| Format(expression, formatExpression) |
|
|
NAMED NUMBER FORMAT EXPRESSIONS
|
| Named Part |
Description
|
| General Number |
Number displayed normally, with
no separators. |
| Currency |
Number displayed with currency
symbol, thousand separators and decimal places. The actual format
depends on the locale. |
| Fixed |
Displays at least one digit
on the left of the decimal point, and two digits to the right
of the point. |
| Standard |
Same output as Fixed, but with a thousands separator. |
| Percent |
Output is multiplied by 100 and
has a % sign at the front. Displayed with two decimal places. |
| Scientific |
Output is displayed as standard scientific (eg.
6.42E+01). |
| Yes/No |
Displays No if number is 0,
otherwise displays Yes. |
| True/False |
Displays False if number is 0, otherwise displays
True. |
| On/Off |
Displays Off if number is 0, otherwise
displays On. |
|
|
The following example uses the Currency format expression
to print a value according to the country's settings. In the UK,
this would show as £64.20.
|
| Debug.Print Format(64.2, "Currency")
|
|
|
NAMED DATE/TIME FORMAT EXPRESSIONS:
|
| Named Part |
Description
|
| General Date |
Displays a general date. |
| Long Date |
Displays a long date according the system's long
date settings. |
| Medium Date |
Displays a medium date according the system's
long date settings. |
| Short Date |
Displays a short date according the system's long
date settings. |
| Long Time |
Displays a long time according to the system's
long time settings, includes hours, minutes and seconds. |
| Medium Time |
Displays the time in 12-hour format with AM/PM
adornments. |
| Short Time |
Displays the time in 24-hour format. |
|
|
|
|
If you don't find what you are looking for. Please click
here to submit your query, our experts will reply soon.
|
Software Development
Search Engine Optimization
Web Development
Presentation / Animation
Games Development
Web Hosting
Templates & Layouts
Tutorials
E-mail Sample
