Computers and Technology

VBScript – FormatDateTime
By Shaun Vermaak

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:
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)

WScript.Echo FormatDateTime(Now(),vbGeneralDate)
-OR-
WScript.Echo FormatDateTime(Now(),0)
Sample return “2006/09/12 10:10:28 PM”

WScript.Echo FormatDateTime(Now(),vbLongDate)
-OR-
WScript.Echo FormatDateTime(Now(),1)
Sample return “12 September 2006″

WScript.Echo FormatDateTime(Now(),vbShortDate)
-OR-
WScript.Echo FormatDateTime(Now(),2)
Sample return “2006/09/12″

WScript.Echo FormatDateTime(Now(),vbLongTime)
-OR-
WScript.Echo FormatDateTime(Now(),3)
Sample return “10:14:58 PM”

WScript.Echo FormatDateTime(Now(),vbShortTime)
-OR-
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″.

WScript.Echo FormatDateTime(“2006/09/12″,vbShortTime)
Sample return “00:00″

Shaun Vermaak – www.ITtelligence.co.za

Article Source: http://EzineArticles.com/?expert=Shaun_Vermaak
http://EzineArticles.com/?VBScript—FormatDateTime&id=297336

Related post

VBScript – Pass DOS-Like Arguments to Your Script for Flexibility and Control
...

ASP
...

Create ASP in Minutes
...

An Introduction to .NET Framework
...

Web Design – Leads You to the World of Web Technology
...