Functions

The following functions can be used in the definition of the terms:

Abs	Returns the absolute value of a numeric expression
Asc	Returns an integer representing the ANSI code of the first character of the specified string.
Atn	Calculates the arc tangent of a numeric expression
CBool	Converts a numeric or string expression Boolean (True / False)
CByte	Converts a given value of Byte type
CCur	Converts a value to data Currency type
CDate	Converts a given value of Date (date) type
CDbl	Converts a given value of Double (double precision) type
Chr	Returns the ANSI character code corresponding to the specified
CInt	Converts a given value of Integer type
CLng	Converts a given value of Long type
Cos	Calculates the cosine of a numeric expression
CSng	Converts a value to a Single (single-precision)
Dates	Returns the current system date
DateAdd	Calculates the date resulting from the addition of a certain period of time on the specified date
DateDiff	Calculates the date resulting from the subtraction of a certain period of time from the date specified
DatePart	Extracts the request portion of the date (day, quarter hour, etc..)
DateSerial	Returns the date corresponding to the day, month, year and time specified in localized format).
DateValue	Returns the value corresponding to the Date.
Day	Returns an integer representing the day of the month (1 .. 31) from a definition of date / time.
Exp	Exponent. Returns e (tThe base of natural logarithms) raised to the specified power.
Eval	Returns the result of an expression, specified as a string with VBScript syntax
Fix	Returns the integer portion of a number. If the number is negative, Fix returns a negative integer immediately above (or equal to) the specified number
FormatCurrency	Returns an expression formatted as currency, using the currency symbol defined in the Control Panel.
FormatDateTime	Returns an expression formatted as a date or time
FormatNumber	Returns an expression formatted as a numeric value.
FormatPercent	Returns an expression formatted as a percentage.
GetLocale	Returns LocaleId (LCID) set on the computer.
Hex	Returns a string representing the hexadecimal value of a numeric expression.
Hour	Returns an integer representing the hour of the day (0 .. 23) from a definition of date / time.
InStr	Search for the first occurrence of one string within another, starting from the specified position.
InStrRev	Search backward for the first occurrence of one string within another, starting from the specified position.
Int	Returns the integer portion of a number. If the number is negative, Int returns the immediately negative integer less than (or equal to) the specified number.
IsDate	Returns a Boolean value (True / False) that specifies whether the given expression is interpreted as a valid date.
IsNumeric	Returns a Boolean value (True / False) that specifies whether the given expression is validly interpreted as a numeric value.
LCase	Converts all alphabetic characters in a string into the corresponding lowercase.
Left	Returns the specified number of characters in a string, starting from the left.
Len	Returns the number of characters in a string.
Log	Returns the natural logarithm (base e) of a numeric expression.
Ltrim	Remove the leading spaces (i.e. to the left) of a string
Mid	Returns a string extracting the required number of characters from the given string, starting at the specified position.
Minute	Returns an integer representing the minute of the hour (0 .. 59) from a definition of date / time
Mod	Returns the remainder of a arithmetic division
Month	Returns an integer representing the month of the year (1 .. 12), starting with a definition of date / time
MonthName	Returns the localized name of the specified month (1 .. 12)
Now	Returns current date and time in local format
Oct	Returns a string that represents the octal representation of the number
Replace	Returns a string in which a certain portion has been replaced by a replacement string specified for a given number of occurrences.
RGB	Returns an integer representing the color code which results from the Red Green and Blue components specified.
Right	Returns the specified number of characters in a string, starting from the far right
Rnd	Returns a pseudo-random number
Round	Returns a value rounded to the specified number of decimal places.
Rtrim	Remove the spaces terminals (right) of a string.
Second	Returns an integer representing the second (0 .. 59) of the minute, from a definition of date / time.
Sgn	Returns an integer that identifies the sign of a number, expressing the multiplier (number 1 = positive, 0 = equal numbers 0, -1 = negative number).
Sin	Returns the Sine of a numeric expression.
Space	Returns a string consisting of a specified number of spaces.
Sqr	Calculates the square root of a numeric expression
StrComp	Returns a value (-1/0/1/Null) that represents the result of the comparison between the specified strings.
String	Returns a string formed by concatenating the specified number of times a character.
StrReverse	Returns a string in which the character order is reversed compared to the original string
Tan	Calculates the tangent of a numeric expression
Time	Returns the current system time
Timer	Returns the number of seconds elapsed since midnight (00:00) of the current day.
TimeSerial	Returns the hour, the hour, minute, and second, in localized format.
TimeValue	Returns a Date value type that contains the time corresponding to the definition of the specified string.
Trim	Remove the leading spaces (left) and end (right) of a string.
UCase	Converts all alphabetic characters in a string in the corresponding uppercase characters.
Weekday	Returns an integer representing the day of the week (1 .. 7) represented by the specified date. The ordinal is determined by the starting day of the week specified.
WeekdayName	Returns the localized name of the specified day of the week (1 .. 7), taking into account the starting day of the week set.
Year	Returns a four-digit integer representing the year of establishment of the date / time.