VBA - Format DateTime Function

A Function, which helps the developers to format and return a valid date and time expression.

Syntax

FormatDateTime(date,format) 

Parameter Description

• Date − A required parameter.

• Format − An optional parameter. The Value that specifies the date or time format to be used. It can take the following values.

  • 0 = vbGeneralDate - Default

  • 1 = vbLongDate - Returns date

  • 2 = vbShortDate - Returns date

  • 3 = vbLongTime - Returns time

  • 4 = vbShortTime - Returns time

Example

Add a button and add the following function.

Private Sub Constant_demo_Click()
   d = ("2013-08-15 20:25")
   msgbox("Line 1 : " & FormatDateTime(d))
   msgbox("Line 2 : " & FormatDateTime(d,1))
   msgbox("Line 3 : " & FormatDateTime(d,2))
   msgbox("Line 4 : " & FormatDateTime(d,3))
   msgbox("Line 5 : " & FormatDateTime(d,4))
End Sub   

When you execute the above function, it produces the following output.

Line 1 : 15/08/2013 8:25:00 PM 
Line 2 : Thursday, 15 August 2013
Line 3 : 15/08/2013
Line 4 : 8:25:00 PM
Line 5 : 20:25