10.13 Minute

The Minute function returns a number between 0 and 59 that represents the minute of the hour.

Syntax

Minute(time)

Parameter

Description

time

Required. Any expression that can represent a time

Example 1

document.write(Now & "

")document.write(Minute(Now))Output:1/15/2002 10:34:39 AM34

10.14 Month

The Month function returns a number between 1 and 12 that represents the month of the year.

Syntax

Month(date)

Parameter

Description

date

Required. Any expression that can represent a date

Example 1

document.write(Date & "

")document.write(Month(Date))Output:1/15/20021

10.15 MonthName

The MonthName function returns the name of the specified month.

Syntax

MonthName(month[,abbreviate])

Parameter

Description

month

Required. Specifies the number of the month (January is 1, February is 2, etc.)

abbreviate

Optional. A Boolean value that indicates if the month name is to be abbreviated. Default is False

Example 1

document.write(MonthName(8))Output:August

10.16 Now

The Now function returns the current date and time according to the setting of your computer's system date and time.

Now

Example 1

document.write(Now)Output:1/15/2002 10:52:15 AM

## Sunday, January 13, 2008

### Vb Script Tutorial

10.10 FormatDateTime

The FormatDateTime function formats and returns a valid date or time expression.

Syntax

FormatDateTime(date,format)

Parameter

Description

date

Required. Any valid date expression (like Date() or Now())

format

Optional. A Format value that specifies the date/time format to use

Example 1

document.write("The current date is: ")document.write(FormatDateTime(Date()))Output:The current date is: 2/22/2001

10.11 Hour

The Hour function returns a number between 0 and 23 that represents the hour of the day.

Syntax

Hour(time)

Parameter

Description

time

Required. Any expression that can represent a time

Example 1

document.write(Now & "

")document.write(Hour(Now))Output:1/15/2002 10:07:47 AM10

10.12 IsDate

The IsDate function returns a Boolean value that indicates if the evaluated expression can be converted to a date. It returns True if the expression is a date or can be converted to a date; otherwise, it returns False.

Note: The IsDate function uses local setting to determine if a string can be converted to a date ("January" is not a month in all languages.)

Syntax

IsDate(expression)

Parameter

Description

expression

Required. The expression to be evaluated

Example 1

document.write(IsDate("April 22, 1947") & "

")document.write(IsDate(#11/11/01#) & "

")document.write(IsDate("#11/11/01#") & "

")document.write(IsDate("Hello World!"))Output:TrueTrueFalseFalse

The FormatDateTime function formats and returns a valid date or time expression.

Syntax

FormatDateTime(date,format)

Parameter

Description

date

Required. Any valid date expression (like Date() or Now())

format

Optional. A Format value that specifies the date/time format to use

Example 1

document.write("The current date is: ")document.write(FormatDateTime(Date()))Output:The current date is: 2/22/2001

10.11 Hour

The Hour function returns a number between 0 and 23 that represents the hour of the day.

Syntax

Hour(time)

Parameter

Description

time

Required. Any expression that can represent a time

Example 1

document.write(Now & "

")document.write(Hour(Now))Output:1/15/2002 10:07:47 AM10

10.12 IsDate

The IsDate function returns a Boolean value that indicates if the evaluated expression can be converted to a date. It returns True if the expression is a date or can be converted to a date; otherwise, it returns False.

Note: The IsDate function uses local setting to determine if a string can be converted to a date ("January" is not a month in all languages.)

Syntax

IsDate(expression)

Parameter

Description

expression

Required. The expression to be evaluated

Example 1

document.write(IsDate("April 22, 1947") & "

")document.write(IsDate(#11/11/01#) & "

")document.write(IsDate("#11/11/01#") & "

")document.write(IsDate("Hello World!"))Output:TrueTrueFalseFalse

### Vb Script Tutorial

10.7 DateSerial

The DateSerial function returns a Variant of subtype Date for a specified year, month, and day.

Syntax

DateSerial(year,month,day)

Parameter

Description

year

Required. A number between 100 and 9999, or a numeric expression. Values between 0 and 99 are interpreted as the years 1900–1999. For all other year arguments, use a complete four-digit year

month

Required. Any numeric expression

day

Required. Any numeric expression

Example 1

document.write(DateSerial(1996,2,3) & "

")document.write(DateSerial(1990-20,9-2,1-1))Output:2/3/19966/30/1970

10.8 DateValue

The DateValue function returns a Variant of subtype Date.

Note: If the year part of date is omitted this function will use the current year from the computer's system date.

Note: If the date parameter includes time information it will not be returned. However, if date includes invalid time information, a run-time error will occur.

Syntax

DateValue(date)

Parameter

Description

date

Required. A date from January 1, 100 through December 31, 9999 or any expression that can represent a date, a time, or both a date and time

Example 1

document.write(DateValue("31-Jan-02") & "

")document.write(DateValue("31-Jan") & "

")document.write(DateValue("31-Jan-02 2:39:49 AM"))Output:1/31/20021/31/20021/31/2002

10.9 Day

The Day function returns a number between 1 and 31 that represents the day of the month.

Syntax

Day(date)

Parameter

Description

date

Required. Any expression that can represent a date

Example 1

document.write(Date & "

")document.write(Day(Date))Output:1/14/200214

The DateSerial function returns a Variant of subtype Date for a specified year, month, and day.

Syntax

DateSerial(year,month,day)

Parameter

Description

year

Required. A number between 100 and 9999, or a numeric expression. Values between 0 and 99 are interpreted as the years 1900–1999. For all other year arguments, use a complete four-digit year

month

Required. Any numeric expression

day

Required. Any numeric expression

Example 1

document.write(DateSerial(1996,2,3) & "

")document.write(DateSerial(1990-20,9-2,1-1))Output:2/3/19966/30/1970

10.8 DateValue

The DateValue function returns a Variant of subtype Date.

Note: If the year part of date is omitted this function will use the current year from the computer's system date.

Note: If the date parameter includes time information it will not be returned. However, if date includes invalid time information, a run-time error will occur.

Syntax

DateValue(date)

Parameter

Description

date

Required. A date from January 1, 100 through December 31, 9999 or any expression that can represent a date, a time, or both a date and time

Example 1

document.write(DateValue("31-Jan-02") & "

")document.write(DateValue("31-Jan") & "

")document.write(DateValue("31-Jan-02 2:39:49 AM"))Output:1/31/20021/31/20021/31/2002

10.9 Day

The Day function returns a number between 1 and 31 that represents the day of the month.

Syntax

Day(date)

Parameter

Description

date

Required. Any expression that can represent a date

Example 1

document.write(Date & "

")document.write(Day(Date))Output:1/14/200214

### Vb Script Tutorial

10.6 DatePart

The DatePart function returns the specified part of a given date.

Syntax

DatePart(interval,date[,firstdayofweek[,firstweekofyear]])

Parameter

Description

interval

Required. The interval of time to return.

Can take the following values:

yyyy - Year

q - Quarter

m - Month

y - Day of year

d - Day

w - Weekday

ww - Week of year

h - Hour

n - Minute

s - Second

date

Required. Date expression to evaluate

firstdayofweek

Optional. Specifies the day of the week.

Can take the following values:

0 = vbUseSystemDayOfWeek - Use National Language Support (NLS) API setting

1 = vbSunday - Sunday (default)

2 = vbMonday - Monday

3 = vbTuesday - Tuesday

4 = vbWednesday - Wednesday

5 = vbThursday - Thursday

6 = vbFriday - Friday

7 = vbSaturday - Saturday

firstweekofyear

Optional. Specifies the first week of the year.

Can take the following values:

0 = vbUseSystem - Use National Language Support (NLS) API setting

1 = vbFirstJan1 - Start with the week in which January 1 occurs (default)

2 = vbFirstFourDays - Start with the week that has at least four days in the new year

3 = vbFirstFullWeek - Start with the first full week of the new year

Example 1

document.write(Date & "

")document.write(DatePart("d",Date))Output:1/14/200214

The DatePart function returns the specified part of a given date.

Syntax

DatePart(interval,date[,firstdayofweek[,firstweekofyear]])

Parameter

Description

interval

Required. The interval of time to return.

Can take the following values:

yyyy - Year

q - Quarter

m - Month

y - Day of year

d - Day

w - Weekday

ww - Week of year

h - Hour

n - Minute

s - Second

date

Required. Date expression to evaluate

firstdayofweek

Optional. Specifies the day of the week.

Can take the following values:

0 = vbUseSystemDayOfWeek - Use National Language Support (NLS) API setting

1 = vbSunday - Sunday (default)

2 = vbMonday - Monday

3 = vbTuesday - Tuesday

4 = vbWednesday - Wednesday

5 = vbThursday - Thursday

6 = vbFriday - Friday

7 = vbSaturday - Saturday

firstweekofyear

Optional. Specifies the first week of the year.

Can take the following values:

0 = vbUseSystem - Use National Language Support (NLS) API setting

1 = vbFirstJan1 - Start with the week in which January 1 occurs (default)

2 = vbFirstFourDays - Start with the week that has at least four days in the new year

3 = vbFirstFullWeek - Start with the first full week of the new year

Example 1

document.write(Date & "

")document.write(DatePart("d",Date))Output:1/14/200214

### Vb Script Tutorial

10.4 DateAdd

The DateAdd function returns a date to which a specified time interval has been added.

Syntax DateAdd(interval,number,date)

Parameter

Description

interval

Required. The interval you want to add

Can take the following values:

yyyy - Year

q - Quarter

m - Month

y - Day of year

d - Day

w - Weekday

ww - Week of year

h - Hour

n - Minute

s - Second

number

Required. The number of interval you want to add. Can either be positive, for dates in the future, or negative, for dates in the past

date

Required. Variant or literal representing the date to which interval is added

Example 1

'Add one month to January 31, 2000document.write(DateAdd("m",1,"31-Jan-00"))Output:2/29/2000

Example 2

'Add one month to January 31, 2001document.write(DateAdd("m",1,"31-Jan-01"))Output:2/28/2001

10.5 DateDiff

The DateDiff function returns the number of intervals between two dates.

Syntax

DateDiff(interval,date1,date2[,firstdayofweek[,firstweekofyear]])

Parameter

Description

interval

Required. The interval you want to use to calculate the differences between date1 and date2

Can take the following values:

yyyy - Year

q - Quarter

m - Month

y - Day of year

d - Day

w - Weekday

ww - Week of year

h - Hour

n - Minute

s - Second

date1,date2

Required. Date expressions. Two dates you want to use in the calculation

firstdayofweek

Optional. Specifies the day of the week.

Can take the following values:

0 = vbUseSystemDayOfWeek - Use National Language Support (NLS) API setting

1 = vbSunday - Sunday (default)

2 = vbMonday - Monday

3 = vbTuesday - Tuesday

4 = vbWednesday - Wednesday

5 = vbThursday - Thursday

6 = vbFriday - Friday

7 = vbSaturday - Saturday

firstweekofyear

Optional. Specifies the first week of the year.

Can take the following values:

0 = vbUseSystem - Use National Language Support (NLS) API setting

1 = vbFirstJan1 - Start with the week in which January 1 occurs (default)

2 = vbFirstFourDays - Start with the week that has at least four days in the new year

3 = vbFirstFullWeek - Start with the first full week of the new year

Example 1

document.write(Date & "

")document.write(DateDiff("m",Date,"12/31/2002") & "

")document.write(DateDiff("d",Date,"12/31/2002") & "

")document.write(DateDiff("n",Date,"12/31/2002"))Output:1/14/200211351505440

The DateAdd function returns a date to which a specified time interval has been added.

Syntax DateAdd(interval,number,date)

Parameter

Description

interval

Required. The interval you want to add

Can take the following values:

yyyy - Year

q - Quarter

m - Month

y - Day of year

d - Day

w - Weekday

ww - Week of year

h - Hour

n - Minute

s - Second

number

Required. The number of interval you want to add. Can either be positive, for dates in the future, or negative, for dates in the past

date

Required. Variant or literal representing the date to which interval is added

Example 1

'Add one month to January 31, 2000document.write(DateAdd("m",1,"31-Jan-00"))Output:2/29/2000

Example 2

'Add one month to January 31, 2001document.write(DateAdd("m",1,"31-Jan-01"))Output:2/28/2001

10.5 DateDiff

The DateDiff function returns the number of intervals between two dates.

Syntax

DateDiff(interval,date1,date2[,firstdayofweek[,firstweekofyear]])

Parameter

Description

interval

Required. The interval you want to use to calculate the differences between date1 and date2

Can take the following values:

yyyy - Year

q - Quarter

m - Month

y - Day of year

d - Day

w - Weekday

ww - Week of year

h - Hour

n - Minute

s - Second

date1,date2

Required. Date expressions. Two dates you want to use in the calculation

firstdayofweek

Optional. Specifies the day of the week.

Can take the following values:

0 = vbUseSystemDayOfWeek - Use National Language Support (NLS) API setting

1 = vbSunday - Sunday (default)

2 = vbMonday - Monday

3 = vbTuesday - Tuesday

4 = vbWednesday - Wednesday

5 = vbThursday - Thursday

6 = vbFriday - Friday

7 = vbSaturday - Saturday

firstweekofyear

Optional. Specifies the first week of the year.

Can take the following values:

0 = vbUseSystem - Use National Language Support (NLS) API setting

1 = vbFirstJan1 - Start with the week in which January 1 occurs (default)

2 = vbFirstFourDays - Start with the week that has at least four days in the new year

3 = vbFirstFullWeek - Start with the first full week of the new year

Example 1

document.write(Date & "

")document.write(DateDiff("m",Date,"12/31/2002") & "

")document.write(DateDiff("d",Date,"12/31/2002") & "

")document.write(DateDiff("n",Date,"12/31/2002"))Output:1/14/200211351505440

### Vb Script Tutorial

10. Date / Time Functions Syntax with Example

10.1 Write Text: How to write text on a page

10.2 CDATE

The CDate function converts a valid date and time expression to the variant of subtype Date, and returns the result.

Tip: Use the IsDate function to determine if date can be converted to a date or time.

Note: The IsDate function uses local setting to determine if a string can be converted to a date ("January" is not a month in all languages.)

CDate(date)

Parameter

Description

date

Required. Any valid date expression (like Date() or Now())

Example 1

d="April 22, 2001"if IsDate(d) then document.write(CDate(d))end ifOutput:2/22/01

Example 2

d=#2/22/01#if IsDate(d) then document.write(CDate(d))end ifOutput:2/22/01

Example 3

d="3:18:40 AM"if IsDate(d) then document.write(CDate(d))end ifOutput:3:18:40 AM

10.3 Date

The Date function returns the current system date

Syntaxdocument.write("The current system date is: ")document.write(Date)Output:

The current system date is: 1/14/2002

10.1 Write Text: How to write text on a page

10.2 CDATE

The CDate function converts a valid date and time expression to the variant of subtype Date, and returns the result.

Tip: Use the IsDate function to determine if date can be converted to a date or time.

Note: The IsDate function uses local setting to determine if a string can be converted to a date ("January" is not a month in all languages.)

CDate(date)

Parameter

Description

date

Required. Any valid date expression (like Date() or Now())

Example 1

d="April 22, 2001"if IsDate(d) then document.write(CDate(d))end ifOutput:2/22/01

Example 2

d=#2/22/01#if IsDate(d) then document.write(CDate(d))end ifOutput:2/22/01

Example 3

d="3:18:40 AM"if IsDate(d) then document.write(CDate(d))end ifOutput:3:18:40 AM

10.3 Date

The Date function returns the current system date

Syntaxdocument.write("The current system date is: ")document.write(Date)Output:

The current system date is: 1/14/2002

### Vb Script Tutorial

7. Array Functions

Function

Description

Array

Returns a variant containing an array

Filter

Returns a zero-based array that contains a subset of a string array based on a filter criteria

IsArray

Returns a Boolean value that indicates whether a specified variable is an array

Join

Returns a string that consists of a number of substrings in an array

LBound

Returns the smallest subscript for the indicated dimension of an array

Split

Returns a zero-based, one-dimensional array that contains a specified number of substrings

UBound

Returns the largest subscript for the indicated dimension of an array

8. String Functions

Function

Description

InStr

Returns the position of the first occurrence of one string within another. The search begins at the first character of the string

InStrRev

Returns the position of the first occurrence of one string within another. The search begins at the last character of the string

LCase

Converts a specified string to lowercase

Left

Returns a specified number of characters from the left side of a string

Len

Returns the number of characters in a string

LTrim

Removes spaces on the left side of a string

RTrim

Removes spaces on the right side of a string

Trim

Removes spaces on both the left and the right side of a string

Mid

Returns a specified number of characters from a string

Replace

Replaces a specified part of a string with another string a specified number of times

Right

Returns a specified number of characters from the right side of a string

Space

Returns a string that consists of a specified number of spaces

StrComp

Compares two strings and returns a value that represents the result of the comparison

String

Returns a string that contains a repeating character of a specified length

StrReverse

Reverses a string

UCase

Converts a specified string to uppercase

9. Other Functions

Function

Description

CreateObject

Creates an object of a specified type

Eval

Evaluates an expression and returns the result

GetLocale

Returns the current locale ID

GetObject

Returns a reference to an automation object from a file

GetRef

Allows you to connect a VBScript procedure to a DHTML event on your pages

InputBox

Displays a dialog box, where the user can write some input and/or click on a button, and returns the contents

IsEmpty

Returns a Boolean value that indicates whether a specified variable has been initialized or not

IsNull

Returns a Boolean value that indicates whether a specified expression contains no valid data (Null)

IsNumeric

Returns a Boolean value that indicates whether a specified expression can be evaluated as a number

IsObject

Returns a Boolean value that indicates whether the specified expression is an automation object

LoadPicture

Returns a picture object. Available only on 32-bit platforms

MsgBox

Displays a message box, waits for the user to click a button, and returns a value that indicates which button the user clicked

RGB

Returns a number that represents an RGB color value

Round

Rounds a number

ScriptEngine

Returns the scripting language in use

ScriptEngineBuildVersion

Returns the build version number of the scripting engine in use

ScriptEngineMajorVersion

Returns the major version number of the scripting engine in use

ScriptEngineMinorVersion

Returns the minor version number of the scripting engine in use

SetLocale

Sets the locale ID and returns the previous locale ID

TypeName

Returns the subtype of a specified variable

VarType

Returns a value that indicates the subtype of a specified variable

### Vb Script Tutorial

4. Conversion Functions

Function

Description

Asc

Converts the first letter in a string to ANSI code

CBool

Converts an expression to a variant of subtype Boolean

CByte

Converts an expression to a variant of subtype Byte

CCur

Converts an expression to a variant of subtype Currency

CDate

Converts a valid date and time expression to the variant of subtype Date

CDbl

Converts an expression to a variant of subtype Double

Chr

Converts the specified ANSI code to a character

CInt

Converts an expression to a variant of subtype Integer

CLng

Converts an expression to a variant of subtype Long

CSng

Converts an expression to a variant of subtype Single

CStr

Converts an expression to a variant of subtype String

Hex

Returns the hexadecimal value of a specified number

Oct

Returns the octal value of a specified number

5. Format Functions

Top

Function

Description

FormatCurrency

Returns an expression formatted as a currency value

FormatDateTime

Returns an expression formatted as a date or time

FormatNumber

Returns an expression formatted as a number

FormatPercent

Returns an expression formatted as a percentage

6. Math Functions

Top

Function

Description

Abs

Returns the absolute value of a specified number

Atn

Returns the arctangent of a specified number

Cos

Returns the cosine of a specified number (angle)

Exp

Returns e raised to a power

Hex

Returns the hexadecimal value of a specified number

Int

Returns the integer part of a specified number

Fix

Returns the integer part of a specified number

Log

Returns the natural logarithm of a specified number

Oct

Returns the octal value of a specified number

Rnd

Returns a random number less than 1 but greater or equal to 0

Sgn

Returns an integer that indicates the sign of a specified number

Sin

Returns the sine of a specified number (angle)

Sqr

Returns the square root of a specified number

Tan

Returns the tangent of a specified number (angle)

Function

Description

Asc

Converts the first letter in a string to ANSI code

CBool

Converts an expression to a variant of subtype Boolean

CByte

Converts an expression to a variant of subtype Byte

CCur

Converts an expression to a variant of subtype Currency

CDate

Converts a valid date and time expression to the variant of subtype Date

CDbl

Converts an expression to a variant of subtype Double

Chr

Converts the specified ANSI code to a character

CInt

Converts an expression to a variant of subtype Integer

CLng

Converts an expression to a variant of subtype Long

CSng

Converts an expression to a variant of subtype Single

CStr

Converts an expression to a variant of subtype String

Hex

Returns the hexadecimal value of a specified number

Oct

Returns the octal value of a specified number

5. Format Functions

Top

Function

Description

FormatCurrency

Returns an expression formatted as a currency value

FormatDateTime

Returns an expression formatted as a date or time

FormatNumber

Returns an expression formatted as a number

FormatPercent

Returns an expression formatted as a percentage

6. Math Functions

Top

Function

Description

Abs

Returns the absolute value of a specified number

Atn

Returns the arctangent of a specified number

Cos

Returns the cosine of a specified number (angle)

Exp

Returns e raised to a power

Hex

Returns the hexadecimal value of a specified number

Int

Returns the integer part of a specified number

Fix

Returns the integer part of a specified number

Log

Returns the natural logarithm of a specified number

Oct

Returns the octal value of a specified number

Rnd

Returns a random number less than 1 but greater or equal to 0

Sgn

Returns an integer that indicates the sign of a specified number

Sin

Returns the sine of a specified number (angle)

Sqr

Returns the square root of a specified number

Tan

Returns the tangent of a specified number (angle)

## Thursday, January 10, 2008

### VB Script1

1. What is VBScript?

VBScript is a scripting language

A scripting language is a lightweight programming language

VBScript is a light version of Microsoft's programming language Visual Basic

2. How does it Work?

When a VBScript is inserted into a HTML document, the Internet browser will read the HTML and interpret the VBScript. The VBScript can be executed immediately, or at a later event.

Function

Description

CDate

Converts a valid date and time expression to the variant of subtype Date

Date

Returns the current system date

DateAdd

Returns a date to which a specified time interval has been added

DateDiff

Returns the number of intervals between two dates

DatePart

Returns the specified part of a given date

DateSerial

Returns the date for a specified year, month, and day

DateValue

Returns a date

Day

Returns a number that represents the day of the month (between 1 and 31, inclusive)

FormatDateTime

Returns an expression formatted as a date or time

Hour

Returns a number that represents the hour of the day (between 0 and 23, inclusive)

IsDate

Returns a Boolean value that indicates if the evaluated expression can be converted to a date

Minute

Returns a number that represents the minute of the hour (between 0 and 59, inclusive)

Month

Returns a number that represents the month of the year (between 1 and 12, inclusive)

MonthName

Returns the name of a specified month

Now

Returns the current system date and time

Second

Returns a number that represents the second of the minute (between 0 and 59, inclusive)

Time

Returns the current system time

Timer

Returns the number of seconds since 12:00 AM

TimeSerial

Returns the time for a specific hour, minute, and second

TimeValue

Returns a time

Weekday

Returns a number that represents the day of the week (between 1 and 7, inclusive)

WeekdayName

Returns the weekday name of a specified day of the week

VBScript is a scripting language

A scripting language is a lightweight programming language

VBScript is a light version of Microsoft's programming language Visual Basic

2. How does it Work?

When a VBScript is inserted into a HTML document, the Internet browser will read the HTML and interpret the VBScript. The VBScript can be executed immediately, or at a later event.

Function

Description

CDate

Converts a valid date and time expression to the variant of subtype Date

Date

Returns the current system date

DateAdd

Returns a date to which a specified time interval has been added

DateDiff

Returns the number of intervals between two dates

DatePart

Returns the specified part of a given date

DateSerial

Returns the date for a specified year, month, and day

DateValue

Returns a date

Day

Returns a number that represents the day of the month (between 1 and 31, inclusive)

FormatDateTime

Returns an expression formatted as a date or time

Hour

Returns a number that represents the hour of the day (between 0 and 23, inclusive)

IsDate

Returns a Boolean value that indicates if the evaluated expression can be converted to a date

Minute

Returns a number that represents the minute of the hour (between 0 and 59, inclusive)

Month

Returns a number that represents the month of the year (between 1 and 12, inclusive)

MonthName

Returns the name of a specified month

Now

Returns the current system date and time

Second

Returns a number that represents the second of the minute (between 0 and 59, inclusive)

Time

Returns the current system time

Timer

Returns the number of seconds since 12:00 AM

TimeSerial

Returns the time for a specific hour, minute, and second

TimeValue

Returns a time

Weekday

Returns a number that represents the day of the week (between 1 and 7, inclusive)

WeekdayName

Returns the weekday name of a specified day of the week

Subscribe to:
Posts (Atom)