Author: Shaun Vermaak Added: February 8, 2007
This article will run through some examples on how to use VBScript to change a date and/or time into different formats.
The function that makes this easier is called FormatDateTime.
PLEASE NOTE:
The format of the date and time can vary from one computer to the next because it is displayed as per settings in the "Regional and Language Options" in the "Control Panel".
Syntax:
<![CDATA[FormatDateTime(Date,Format)]]>
Date:
Any valid date expression Format:
vbGeneralDate -OR- 0 : Short date and long time
vbLongDate -OR- 1 : Long date
vbShortDate -OR- 2 : Short date
vbLongTime -OR- 3 : Long time
vbShortTime -OR- 4 : Short time (24-hour format)
<![CDATA[WScript.Echo FormatDateTime(Now(),vbGeneralDate)]]>-OR- <![CDATA[WScript.Echo FormatDateTime(Now(),0)]]>
Sample return "2006/09/12 10:10:28 PM"
<![CDATA[WScript.Echo FormatDateTime(Now(),vbLongDate)]]>-OR- <![CDATA[WScript.Echo FormatDateTime(Now(),1)]]>
Sample return "12 September 2006"
<![CDATA[WScript.Echo FormatDateTime(Now(),vbShortDate)]]>-OR- <![CDATA[WScript.Echo FormatDateTime(Now(),2)]]>
Sample return "2006/09/12"
<![CDATA[WScript.Echo FormatDateTime(Now(),vbLongTime)]]>-OR- <![CDATA[WScript.Echo FormatDateTime(Now(),3)]]>
Sample return "10:14:58 PM"
<![CDATA[WScript.Echo FormatDateTime(Now(),vbShortTime)]]>-OR- <![CDATA[WScript.Echo FormatDateTime(Now(),4)]]>
Sample return "12 September 2006"
PLEASE NOTE:
If you replace Now() with a fixed date without a time, in each case where normally a time is shown, it will be omitted (show only a date) and where only a time is shown (eg. vbShortTime) it will return "00:00".
<![CDATA[WScript.Echo FormatDateTime("2006/09/12",vbShortTime)]]>
Sample return "00:00"
|
