Login  Search QTPWorld.com 
Chapters
 Upcoming Trainings
 QTP Interview Questions
 VB Script  Part I
 VB Script  Part II
 VB Script  Part III
 Working with Files using FSO
 Excel
 Actions
 Functions
 Difference between Action and Function
 Parameterization
 Object Repository
 Descriptive Programming
 Regular Expression
 Error Handling & Recovery Scenario
 Output Values
 Database Connections
 Automation Object Model
 Synchronization
 Environment Variables
 XML
 asdas
Contact Us
info@qtpworld.com  
+91 9886477710 
VB Script  Part II
⇒Array Function:
Array: Returns a Variant containing an array.
Syntax: Array(arglist)
Arguments:
arglist:  (required) argument is a commadelimited list of values that are assigned to the elements of an array contained with the Variant. If no arguments are specified, an array of zero length is created. 
Example:
A = Array(10,20,30) Print A(0) 'Output > 10 Print A(1) 'Output > 20 Print A(2) 'Output >30 'Single dimensional Array with five elements Dim Num(5) Num(0)=10 Num(1)=20 Num(2)=30 Num(3)=40 Num(4)=50 Print Num(0) 'Output > 10 Print Num(1) 'Output > 20 Print Num(2) 'Output >30 Print Num(3) 'Output >40 'multidimensional array Dim DNum(3,2) DNum(0,0)=10 DNum(0,1)=20 DNum(1,0)=30 DNum(1,1)=40 DNum(2,0)=50 DNum(2,1)=60 Print DNum(0,0) 'Output > 10 Print DNum(0,1) 'Output > 20 Print DNum(1,0) 'Output >30 Print DNum(1,1) 'Output >40 Print DNum(2,0) 'Output >50 Print DNum(2,1) 'Output >60
⇒IsArray Function
IsArray: Returns a Boolean value indicating whether a variable is an array.
Syntax: IsArray(varname)
Arguments:
varname:  Can be any variable. 
Example:
'IsArray Dim Arr Dim NArr Arr = Array(10,20,30) Print IsArray(Arr) 'Output >True Print IsArray(NArr) 'Output >False
⇒LBound Function
LBound: Returns the smallest available subscript for the indicated dimension of an array.
Syntax: LBound(arrayname[, dimension])
Arguments:
arrayname:  Name of the array variable; follows standard variable naming conventions. 
dimension:  Whole number indicating which dimension's lower bound is returned. Use 1 for the first dimension, 2 for the second, and so on. If dimension is omitted, 1 is assumed. 
Example:
'LBound Dim LArr LArr = Array(10,20,30) Print Lbound(LArr,1) 'Output > 0 ''multidimensional array Dim Lmarr(3,2) Print LBound(Lmarr,2) 'Output > 0
⇒UBound Function
UBound: Returns the largest available subscript for the indicated dimension of an array.
Syntax: UBound(arrayname[, dimension])
Arguments:
arrayname:  (Required) Name of the array variable; follows standard variable naming conventions. 
dimension:  (Optional) Whole number indicating which dimension's upper bound is returned. Use 1 for the first dimension, 2 for the second, and so on. If dimension is omitted, 1 is assumed. 
Example:
'UBound Dim UArr UArr = Array(10,20,30) Print Ubound(UArr,1) 'Output > 2 ''multidimensional array Dim Umarr(3,2,4) Print UBound(Umarr,1) 'Output > 3 Print UBound(Umarr,2) 'Output > 2 Print UBound(Umarr,3) 'Output > 4
⇒Date Function
Date: Returns the current system date.
Syntax: Date
Example:
'Date Print Date 'Output >Displays the current system date.
⇒Time Function
Time: Returns a Variant of subtype Date indicating the current system time.
Syntax: Time
Example:
'Time
Print Time
'Output > Displays the current system time.
⇒DateAdd Function
DateAdd: Returns a date to which a specified time interval has been added.
Syntax: DateAdd(interval, number, date)
Arguments:
interval:  (Required) String expression that is the interval you want to add. See Settings section for values. 
number:  (Required) Numeric expression that is the number of interval you want to add. The numeric expression 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:
'DateAdd Print DateAdd("yyyy",1,"November 01, 2010") 'Output>11/1/2011
⇒DateDiff Function
DateDiff: Returns the number of intervals between two dates.
Syntax: DateDiff(interval, date1, date2 [,firstdayofweek[, firstweekofyear]])
Arguments:
interval:  (Required) String expression that is the interval you want to use to calculate the differences between date1 and date2. 
date1, date2:  (Required) Date expressions. Two dates you want to use in the calculation. 
firstdayofweek:  (Optional) Constant that specifies the day of the week. If not specified, Sunday is assumed. 
firstweekofyear:  (Optional) Constant that specifies the first week of the year. If not specified, the first week is assumed to be the week in which January 1 occurs. 
Example:
'DateDiff Print DateDiff("yyyy","November 01, 2008","November 01, 2009") 'Output> 1
⇒DatePart Function
DatePart: Returns the specified part of a given date.
Syntax: DatePart(interval, date[, firstdayofweek[, firstweekofyear]])
Arguments:
interval:  (Required) String expression that is the interval of time you want to return. 
date:  (Required) Date expression you want to evaluate. 
firstdayof week:  (Optional) Constant that specifies the day of the week. If not specified, Sunday is assumed. 
firstweekofyear:  (Optional) Constant that specifies the first week of the year. If not specified, the first week is assumed to be the week in which January 1 occurs. 
'DatePart Print DatePart("yyyy","November 01, 2008") 'Output> 2008
⇒Day Function
Day: Returns a whole number between 1 and 31, inclusive, representing the day of the month.
Syntax: Day(date)
date:  expression represent a date. If date contains Null, Null is returned. 
Example:
'Day Print Day("11012010") 'Output >1 Print Day("11/1/2010") 'Output >1 Print Day("November 01, 2010") 'Output >1
⇒Month Function
Month: Returns a whole number between 1 and 12, inclusive, representing the month of the year.
Syntax: Month(date)
date:  expression represent a date. If date contains Null, Null is returned. 
Example:
⇒MonthName Function
Example:
Weekday Function
⇒WeekdayName Function
Example:
⇒Year Function
Example:
⇒Hour Function
'Month Print Month("11012010") 'Output >11 Print Month("11/1/2010") 'Output >11 Print Month("November 01, 2010") 'Output >11
⇒MonthName Function
MonthName: Returns a string indicating the specified month.
Syntax: MonthName(month[, abbreviate])
Arguments:
month:  (Required) The numeric designation of the month. For example, January is 1, February is 2, and so on. 
abbreviate:  (Optional) Boolean value that indicates if the month name is to be abbreviated. If omitted, the default is False, which means that the month name is not abbreviated.

Example:
'MonthName Print MonthName(11,true) 'Output >Nov Print MonthName(12,false) 'Output >December Print MonthName(9) 'Output >September
Weekday Function
⇒Weekday:
Returns a whole number representing the day of the week.
Syntax: Weekday(date, [firstdayofweek])
Arguments:
date:  Any expression that can represent a date. If date contains Null, Null is returned. 
firstdayofweek:  A constant that specifies the first day of the week. If omitted, vbSunday is assumed. 
Example:
'Weekday Print Weekday("November 03, 2010") 'Output >4 (which means its a Wednesday)
⇒WeekdayName Function
WeekdayName: Returns a string indicating the specified day of the week.
Syntax: WeekdayName(weekday, abbreviate, firstdayofweek)
Arguments:
weekday:  (Required) The numeric designation for the day of the week. Numeric value of each day depends on setting of the firstdayofweek setting. 
abbreviate:  (Optional) Boolean value that indicates if the weekday name is to be abbreviated. If omitted, the default is False, which means that the weekday name is not abbreviated. 
firstdayofweek:  (Optional) Numeric value indicating the first day of the week. 
Example:
'WeekdayName
Print WeekdayName(4)
'Output >Wednesday
⇒Year Function
Year: Returns a whole number representing the year.
Syntax: Year(date)
Arguments:
date:  Any expression that can represent a date. If date contains Null, Null is returned. 
'Year Print Year("11012010") 'Output >2010 Print Year("11/1/2010") 'Output >2010 Print Year("November 01, 2010") 'Output >2010
⇒Hour Function
Hour: Returns a whole number between 0 and 23, inclusive, representing the hour of the day.
Syntax: Hour(time)
Arguments:
time:  is any expression that can represent a time. If time contains Null, Null is returned. 
Example:
'Hour
Print Hour(Now)
'Output >Displays the current system hour.
⇒Minute Function
Example:
⇒Second Function
Example:
⇒Now Function
Minute: Returns a whole number between 0 and 59, inclusive, representing the minute of the hour.
Syntax: Minute(time)
Arguments:
time:  is any expression that can represent a time. If time contains Null, Null is returned. 
Example:
'Minute Print Minute(Now) 'Output >Displays the current system minute.
⇒Second Function
Second: Returns a whole number between 0 and 59, inclusive, representing the second of the minute.
Syntax: Second(time)
Arguments:
time:  is any expression that can represent a time. If time contains Null, Null is returned. 
Example:
'Second
Print Second(Now)
'Output >Displays the current system Second.
⇒Now Function
Now: Returns the current date and time according to the setting of your computer's system date and time.
Syntax: Now
Example:
⇒TimeSerial Function
Example:
⇒TimeValue Function
'Now Print Now 'Output >Displays the current system date & time.
⇒TimeSerial Function
TimeSerial: Returns a Variant of subtype Date containing the time for a specific hour, minute, and second.
Syntax: TimeSerial(hour, minute, second)
Arguments:
hour:  Number between 0 (12:00 A.M.) and 23 (11:00 P.M.), inclusive, or a numeric expression. 
minute:  Any numeric expression. 
second:  Any numeric expression. 
Example:
'TimeSerial
Print Timeserial(13,30,00)
'Output >1:30:00 PM
⇒TimeValue Function
TimeValue: Returns a Variant of subtype Date containing the time.
Syntax: TimeValue(time)
Arguments:
time:  is usually a string expression representing a time from 0:00:00 (12:00:00 A.M.) to 23:59:59 (11:59:59 P.M.), inclusive. However, time can also be any expression that represents a time in that range. If time contains Null, Null is returned.

Example:
'TimeValue Print TimeValue("16:30:00") 'Output >4:30:00 PM