# Caché Basic Functions

• Abs – Returns the absolute value of a number.
• Asc – Returns the ANSI character code corresponding to the first character in a string.
• Atn – Returns the arctangent of a number.
• Case – Compares a target to cases and returns the value associated with the first matching case.
• Chr – Returns the character corresponding to the specified ANSI character code.
• Cos – Returns the cosine of an angle.
• Date – Returns the current system date.
• DateAdd – Returns a date to which a specified time interval has been added.
• DateConvert – Converts dates between internal and external formats.
• 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.
• DateTimeConvert – Converts date/time between internal and external formats.
• Day – Returns the day of the month as an integer between 1 and 31, inclusive.
• Derived Math Functions – The following non-intrinsic math functions can be derived from the intrinsic math functions:
• Exists – Returns the existence status of variables and their array subnodes.
• Exp – Returns e (the base of natural logarithms) raised to a power.
• Fix – Returns the integer portion of a number.
• Hex – Returns a string representing the hexadecimal value of a number.
• Hour – Returns a whole number between 0 and 23, inclusive, representing the hour of the day.
• Increment – Atomically increments the value of a variable and returns the new value.
• InStr – Returns the position of the first occurrence of one string within another.
• InStrRev – Returns the position of the first occurrence of one string within another, searching from the end of string.
• Int – Returns the integer portion of a number.
• IsObject – Returns a value indicating whether an expression references a valid Automation object.
• Join – Returns a string created by joining a number of array elements.
• LCase – Returns a string that has been converted to lowercase.
• Left – Returns or replaces a specified number of characters from the left end of a string.
• Len – Returns the number of characters in a string or the number of bytes required to store a variable.
• List – Returns elements from a list.
• ListBuild – Creates a list of elements.
• ListExists – Indicates whether an element is present in the list and has a value.
• ListFind – Finds an element in a list.
• ListFromString – Creates a list from a string.
• ListGet – Returns an element from a list.
• ListLength – Returns the number of elements in a list.
• ListNext – Retrieves elements sequentially from a list.
• ListSame – Compares two lists and returns a boolean value.
• ListToString – Creates a string from a list.
• ListValid – Determines if an expression is a list.
• Lock – Obtains a logical lock on a variable name.
• Log – Returns the natural logarithm of a number.
• Mid – Returns or replaces a specified number of characters from a string.
• Minute – Returns a whole number between 0 and 59, inclusive, representing the minute of the hour.
• Month – Returns the month of the year as an integer between 1 and 12, inclusive.
• MonthName – Returns a string indicating the specified month.
• Now – Returns the current date and time according to the setting of your computer's system date and time.
• Oct – Returns a string representing the octal value of a number.
• Piece – Returns the specified substring, using a delimiter.
• Replace – Returns a string in which a specified substring has been replaced with another substring a specified number of times.
• Right – Returns or replaces a specified number of characters from the right end of a string.
• Rnd – Returns a random number.
• Round – Returns a number rounded to a specified number of decimal places.
• Second – Returns a whole number between 0 and 59, inclusive, representing the second of the minute.
• Sgn – Returns an integer indicating the sign of a number.
• Sin – Returns the sine of an angle.
• Space – Returns a string consisting of the specified number of spaces.
• Split – Returns a zero-based, one-dimensional array containing a specified number of substrings.
• Sqr – Returns the square root of a number.
• StrComp – Returns a value indicating the result of a string comparison.
• String – Returns a repeating character string of the length specified.
• StrReverse – Returns a string in which the character order of a specified string is reversed.
• Tan – Returns the tangent of an angle.
• Time – Returns the current system time.
• TimeConvert – Converts time between internal and external formats.
• Timer – Returns the number of seconds that have elapsed since midnight UTC.
• TimeSerial – Returns the time for a specific hour, minute, and second.
• Traverse – Traverses an array and returns the next subscript.
• LTrim, RTrim, and Trim – Returns a copy of a string without leading spaces (LTrim), trailing spaces (RTrim), or both leading and trailing spaces (Trim).
• UCase – Returns a string that has been converted to uppercase.
• Unlock – Releases a logical lock on a variable name.
• Weekday – Returns a whole number representing the day of the week.
• WeekdayName – Returns a string indicating the specified day of the week.
• Year – Returns the year as a four-digit integer.
FeedbackOpens in a new tab