ProgrammerGuide.Net | Step by Step Programmer Guide

ASP Functions

ASP Functions,

Date & Time Function

FunctionDescription
CDateConverts a valid date and time expression to the variant of subtype Date
DateReturns the current system date
DateAddReturns a date to which a specified time interval has been added
DateDiffReturns the number of intervals between two dates
DatePartReturns the specified part of a given date
DateSerialReturns the date for a specified year, month, and day
DateValueReturns a date
DayReturns a number that represents the day of the month (between 1 and 31, inclusive)
FormatDateTimeReturns an expression formatted as a date or time
HourReturns a number that represents the hour of the day (between 0 and 23, inclusive)
IsDateReturns a Boolean value that indicates if the evaluated expression can be converted to a date
MinuteReturns a number that represents the minute of the hour (between 0 and 59, inclusive)
MonthReturns a number that represents the month of the year (between 1 and 12, inclusive)
MonthNameReturns the name of a specified month
NowReturns the current system date and time
SecondReturns a number that represents the second of the minute (between 0 and 59, inclusive)
TimeReturns the current system time
TimerReturns the number of seconds since 12:00 AM
TimeSerialReturns the time for a specific hour, minute, and second
TimeValueReturns a time
WeekdayReturns a number that represents the day of the week (between 1 and 7, inclusive)
WeekdayNameReturns the weekday name of a specified day of the week
YearReturns a number that represents the year

Conversion Function

FunctionDescription
AscConverts the first letter in a string to ANSI code
CBoolConverts an expression to a variant of subtype Boolean
CByteConverts an expression to a variant of subtype Byte
CCurConverts an expression to a variant of subtype Currency
CDateConverts a valid date and time expression to the variant of subtype Date
CDblConverts an expression to a variant of subtype Double
ChrConverts the specified ANSI code to a character
CIntConverts an expression to a variant of subtype Integer
CLngConverts an expression to a variant of subtype Long
CSngConverts an expression to a variant of subtype Single
CStrConverts an expression to a variant of subtype String
HexReturns the hexadecimal value of a specified number
OctReturns the octal value of a specified number

Format Function

FunctionDescription
FormatCurrencyReturns an expression formatted as a currency value
FormatDateTimeReturns an expression formatted as a date or time
FormatNumberReturns an expression formatted as a number
FormatPercentReturns an expression formatted as a percentage

Math Function

FunctionDescription
AbsReturns the absolute value of a specified number
AtnReturns the arctangent of a specified number
CosReturns the cosine of a specified number (angle)
ExpReturns e raised to a power
HexReturns the hexadecimal value of a specified number
IntReturns the integer part of a specified number
FixReturns the integer part of a specified number
LogReturns the natural logarithm of a specified number
OctReturns the octal value of a specified number
RndReturns a random number less than 1 but greater or equal to 0
SgnReturns an integer that indicates the sign of a specified number
SinReturns the sine of a specified number (angle)
SqrReturns the square root of a specified number
TanReturns the tangent of a specified number (angle)

Array Function

FunctionDescription
ArrayReturns a variant containing an array
FilterReturns a zero-based array that contains a subset of a string array based on a filter criteria
IsArrayReturns a Boolean value that indicates whether a specified variable is an array
JoinReturns a string that consists of a number of substrings in an array
LBoundReturns the smallest subscript for the indicated dimension of an array
SplitReturns a zero-based, one-dimensional array that contains a specified number of substrings
UBoundReturns the largest subscript for the indicated dimension of an array

String Function

FunctionDescription
InStrReturns the position of the first occurrence of one string within another. The search begins at the first character of the string
  
InStrRevReturns the position of the first occurrence of one string within another. The search begins at the last character of the string
  
LCaseConverts a specified string to lowercase
LeftReturns a specified number of characters from the left side of a string
LenReturns the number of characters in a string
LTrimRemoves spaces on the left side of a string
RTrimRemoves spaces on the right side of a string
TrimRemoves spaces on both the left and the right side of a string
MidReturns a specified number of characters from a string
ReplaceReplaces a specified part of a string with another string a specified number of times
RightReturns a specified number of characters from the right side of a string
SpaceReturns a string that consists of a specified number of spaces
StrCompCompares two strings and returns a value that represents the result of the comparison
StringReturns a string that contains a repeating character of a specified length
StrReverseReverses a string
UCaseConverts a specified string to uppercase

Other Function

FunctionDescription
CreateObjectCreates an object of a specified type
  
InputBoxDisplays a dialog box, where the user can write some input and/or click on a button, and returns the contents
  
IsEmptyReturns a Boolean value that indicates whether a specified variable has been initialized or not
  
IsNullReturns a Boolean value that indicates whether a specified expression contains no valid data (Null)
  
IsNumericReturns a Boolean value that indicates whether a specified expression can be evaluated as a number
  
IsObjectReturns a Boolean value that indicates whether the specified expression is an automation object
  
LoadPictureReturns a picture object. Available only on 32-bit platforms
  
MsgBoxDisplays a message box, waits for the user to click a button, and returns a value that indicates which button the user clicked
  
RGBReturns a number that represents an RGB color value
RoundRounds a number
ScriptEngineReturns the scripting language in use
ScriptEngineBuildVersionReturns the build version number of the scripting engine in use
ScriptEngineMajorVersionReturns the major version number of the scripting engine in use
ScriptEngineMinorVersionReturns the minor version number of the scripting engine in use
TypeNameReturns the subtype of a specified variable
VarTypeReturns a value that indicates the subtype of a specified variable
Please click here for related products on Amazon!

Jayashee

Add comment

Want to Check Celebrities News?