QTP Functions

Conversion Functions:

Asc(string):Returns the ANSI character code corresponding to the first letter in a string.

CInt(expression): Returns an expression that has been converted to a Variant of subtype Integer

CStr(expression): Returns an expression that has been converted to a Variant of subtype String

CDate(date):Returns an expression that has been converted to a Variant of subtype Date.

Date Functions:

Date:Returns the current system date.

DateAdd(interval, number, date):Returns a date to which a specified time interval has been added.

DateDiff(interval, date1, date2 [,firstdayofweek[, firstweekofyear]]):Returns the number of intervals between two dates.

DatePart(interval, date[, firstdayofweek[, firstweekofyear]]):Returns the specified part of a given date.

DateSerial(year, month, day):Returns a Variant of subtype Date for a specified year, month, and day.

Day(date):Returns a whole number between 1 and 31, inclusive, representing the day of the month

IsDate(expression):Returns a Boolean value indicating whether an expression can be converted to a date.

Now:Returns the current date and time according to the setting of your computer's system date and time.

Weekday(date, [firstdayofweek]):Returns a whole number representing the day of the week.

Year(date):Returns a whole number representing the year.

String Functions:

InStr([start, ]string1, string2[, compare]): Returns the position of the first occurrence of one string within another.

InStrRev(string1, string2[, start[, compare]]): Returns the position of an occurrence of one string within another, from the end of   string.

Join(list[, delimiter]):Returns a string created by joining a number of substrings contained in an array.

LTrim(string),RTrim(string),Trim(string):Returns a copy of a string without leading spaces (LTrim), trailing spaces (RTrim),     or both leading and trailing spaces (Trim).

Len(string | varname):Returns the number of characters in a string or the number of bytes required to store a variable.

Left(string, length): Returns a specified number of

characters from the left side of a string.

Mid(string, start[, length]):Returns a specified number of characters from a string.

Right(string, length): Returns a specified number of characters from the Right side of a string.

StrReverse(string1):Returns a string in which the character order of a specified string is reversed.

StrComp(string1, string2[, compare]):Returns a value indicating the result of a string comparison.

Split(expression[, delimiter[, count[, compare]]]):Returns a zero-based, one-dimensional array containing a specified number of  substrings.

Space(number):Returns a string consisting of the specified number of spaces.