These functions are used to convert one type of value to another (e.g. numeric to text, text to date, etc.)
(Back to Function Types List)
| Description: | Convert ANSI cText to OEM characters |
| Description: | Converts a single character to its numeric (ASCII) value. Example: 'A' -> 65 |
| Description: | Forces an 'Unknown' expression to look like a boolean expression -- it won't necessarily do conversion, it's simply used to satisfy argument type verifications where a function is used that returns an 'Unknown' type inside a function that requires a 'bBoolean' argument |
| Description: | Forces an 'Unknown' expression to look like a text expression -- it won't necessarily do conversion, it's simply used to satisfy argument type verifications where a function is used that returns an 'Unknown' type inside a function that requires a 'cText' argument |
| Description: | Returns a value representing the smallest integer that is greater than or equal to nValue |
| Description: | Converts a value into its character equivalent (e.g. ASCII). Example: 65 -> 'A' |
| Description: | Converts a numeric value into currency text. Example: 3.5 -> '$3.50' |
Function: CurrencyTextToValue
Result-type: Numeric
Arguments: cText
Description: Converts a text currency value to a numeric value. Example: '$3.50' -> 3.5
| Description: | Forces an 'Unknown' expression to look like a date/time expression -- it won't necessarily do conversion, it's simply used to satisfy argument type verifications where a function is used that returns an 'Unknown' type inside a function that requires a 'dDate' argument |
| Description: | Returns the date in text form 'yyyymmdd' if the second argument is 1, otherwise formats the date using the national language specifications (locale IDs) for date/time according to the Windows settings |
| Description: | Converts a Date into text, in the system-specified Date Format (Program Options / Formats) |
| Description: | Converts a Date into text, in the system-specified Date Format (Program Options / Formats), but also forces it to include the year |
| Description: | Decodes an internal Long value into a Time/Date value. Generally for internal use only. |
| Description: | Returns the date in the text form 'd mmm yyyy', for instance '8 July 2005' |
| Description: | Returns the numeric day of the week for the dDate given (1 = Sunday, 7 = Saturday) |
| Description: | Returns a value representing the largest integer that is less than or equal to nValue |
| Arguments: | cFormat, dValue |
| Arguments: | cFormat, nValue |
| Arguments: | cFormat, nValue |
| Description: | Converts a numeric value into text using the base indicated (e.g. 8 for octal, 10 for decimal, 16 for hexadecimal). For decimal, you can also use the simpler Str() function |
| Description: | Truncates a number to an integer |
| Description: | Returns the date in the text form 'mmm d, yyyy', for instance 'July 8, 2005' |
| Description: | Returns the month name as text |
| Description: | Forces an 'Unknown' expression to look like a numeric expression -- it won't necessarily do conversion, it's simply used to satisfy argument type verifications where a function is used that returns an 'Unknown' type inside a function that requires an 'nValue' argument |
| Description: | Convert OEM cText to ANSI characters |
| Description: | Converts a numeric value into percentage text. Example: 3.5 -> '3.5%' |
| Description: | Forces an 'Unknown' expression to look like a record expression -- it won't necessarily do conversion, it's simply used to satisfy argument type verifications where a function is used that returns an 'Unknown' type inside a function that requires a 'record' argument |
| Arguments: | nValue, nDecimalPlaces |
| Description: | Rounds a value to the given number of decimal places |
| Arguments: | nValue [, nLength [, nDecimalPlaces]] |
| Description: | Converts a number to text, with an optional specific length and optional number of decimal places. If the length is > 0 it will be left-padded with spaces if possible, or truncated if necessary. If the whole number can't be shown, '###' will fill the length. |
| Description: | Converts text to a numeric value assuming the base indicated (e.g. 8 for octal, 10 for decimal, 16 for hexadecimal), if possible (up to the first non-numeric character encountered). For decimal, can also use the simpler Val() function. |
| Description: | Converts a text date into a date/time value |
| Description: | Converts a text time into a date/time value |
| Description: | Converts a Time value into text, in the default time format, e.g. HH:MM AM. The time value is actually a date/time value, but the date is ignored. For instance, you can use DateTime() to get the current time as an argument. |
Function: TrimAllNonDigits
Result-type: Text
Arguments: cText
Description: Extracts digits from text, returning only the digits as text. Example: 'cell (212) 555-1212' -> '2125551212'
| Description: | Converts text to a numeric value, if possible (up to the first non-numeric character encountered) |
| Description: | Returns a character representing the type of value the argument represents. 'C' = text (character), 'N' = numeric, 'D' = date, 'B' = boolean, 'R' = record, 'X' = null (error), 'U' = unknown |
Page URL https://CampgroundMaster.com/help/conversion.html
Campground Master Home