¡¡

Visual Basic 2008 Tutorial

Lesson 16: Functions Part V- Formatting Date and Time

¡¡

    Previous Lesson << [Home]>> Next Lesson

16.1 Formatting Date and time using predefined formats

Date and time can be formatted using predefined formats and also user-defined formats.  The predefined formats of date and time are shown in Table 16.1.

 Table 16.1 Predefined formats of date and time

Format

Explanation

Format (Now, ¡°General date¡±)

Formats the current date and time.

Format (Now, ¡°Long Date¡±)

Displays the current date in long format.

Format (Now, ¡°Short date¡±)

Displays current date in short format

Format (Now, ¡°Long Time¡±)

Display the current time in long format.

Format (Now, ¡°Short Time¡±)

Display the current time in short format.

* Instead of "General date", you can also use the abbreviated  format "G" , i.e.  Format (Now, "G"). And for "Long Time", you can use the abbreviated  format "T". As for "Short Time", you may use the abbreviated  format "t"

Example 16.1

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Label1.Text = Format(Now, "General Date")
Label2.Text = Format(Now, "Long Date")
Label3.Text = Format(Now, "short Date")
Label4.Text = Format(Now, "Long Time")
Label5.Text = Format(Now, "Short Time")
End Sub

The output is shown in the diagram below:

¡¡

16.2 Formatting Date and time using user-defined formats

Beside using the predefined  formats, you can also use the user-defined formatting functions. The general format of a user-defined for date/time is

          Format (expression,style)

Table 16.2 Some of the user-defined format functions for  date and time

Format

Explanation

Format (Now, ¡°M¡±)

Displays current month and date

Format (Now, ¡°MM¡±)

Displays current month in double digits.

Format (Now, ¡°MMM¡±)

Displays abbreviated name of the current month

Format (Now, ¡°MMMM¡±)

Displays full name of the current month.

Format (Now, ¡°dd/MM/yyyy¡±)

Displays current date in the day/month/year format.

Format (Now, "MMM,d,yyyy")

Displays current date in the Month, Day, Year Format

Format (Now, "h:mm:ss tt")

Dispalys current time  in hour:minute:second format and show am/pm

Format (Now, "MM/dd/yyyy  h:mm:ss)

Dispalys current date and time  in hour:minute:second format

 Example 16.2

 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click, Button2.Click, Button3.Click

Label1.Text = Format(Now, "M")
Label2.Text = Format(Now, "MM")
Label3.Text = Format(Now, "MMM")
Label4.Text = Format(Now, "MMMM")
Label5.Text = Format(Now, "dd/MM/yyyy")
Label6.Text = Format(Now, "MMM,d,yyyy")
Label7.Text = Format(Now, "h:mm:ss tt")
Label8.Text = Format(Now, "MM/dd/yyyy h:mm:ss tt")

End Sub

The output is shown in the diagram below:

¡¡

   

¡¡

¡¡

  Bookmark and Share

  Previous Lesson<<  [Home ]   >>Next Lesson

¡¡

¡¡ Copyright® Dr.Liew Voon Kiong  Contact: admin@vbtutor.net Privacy Policy]

¡¡

¡¡