Date And Time

Tips >> Visual Basic

MAKE WEB APPLICATION WITHOUT KNOWLEDGE OF CODING? CLICK HERE

 

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.

 

E-mail : sales@virtualsplat.com
Phone : +91-9892413501

Whatsapp Icon +91-9967648641

Whatsapp Icon +91-9967648641