Function Name | Returns | Syntax | Example |
Date Functions | |||
Today | Returns the current date | Today() | Today() + 1 |
Now | Return the current date and time | Now() | Now() |
Last day of the month | Returns the last day of the month of the given date | Last_day_of_month(Date*)
| Last_day_of_month("13/1/2018") = 31/1/2018 |
Day_of | Returns the day of the given date | Day_of(Date*)
| Day_of("13/1/2018") = 13 |
Month_of | Returns the month of the given date | Month_of(Date*) | Month_of("13/1/2018") = 1 |
Year_of | Returns the year of the given date. | Year_of(Date*) | Year_of("13/1/2018") = 2018 |
Day_of_week | Returns the day of week of the given date. | Day_of_week(Date*) | Day_of_week("13/1/2018") = 7 |
Date | Returns a date which is constructed from the given day, month and year. | Date(arg1,arg2,arg3) | Date(1,13,2018) = 1/13/2018 |
* The date format should match the machine's Regional Setting date format. |
|
|
|
Math Functions | |||
Min | Min function returns the smallest value in 2 given values. | Min(num1, num2) | Min(10,2) = 2 Entering more or less than 2 arguments will cause an error.
|
Max | Max function returns the largest value in 2 given values. | Max(num1, num2) | Max(10,2) = 10 Entering more or less than 2 arguments will cause an error.
|
Random | Determines whether the end of the text matches value parameter and returns TRUE/FALSE | Ends_with(text, value) | Ends_with('Original Text', 'xt') = True
|
Text Functions | |||
Left | Left returns the first character or characters in a text string, based on the number of characters you specify. | Left(text, [num_chars])
| Left('Sale Price', 4) = 'Sale' |
Right | Right returns the last character or characters in a text string, based on the number of characters you specify. | Right(text,[num_chars]) | Right('Sale Price', 5) = 'Price' |
Mid | Mid returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify. | Mid(text, start_num, num_chars) | Mid('Fluid Flow',0,5) = 'Fluid' If start_num is less than the length of text, but start_num plus num_chars exceeds the length of text, Mid returns the characters up to the end of text. If start_num is less than 0, Mid returns the #VALUE! error value. If num_chars is negative, Mid returns the #VALUE! error value.
|
Concatenate | Concatenate function joins two text strings into one string.
| Concatenate(text1, text2) | Concatenate('Sale', ' Price') = 'Sale Price' |
Find | Find function returns the position of a specified character or sub-string within a supplied text string.
| Find( find_text, within_text ) | Find( 'T', 'Original Text' ) = 10 |
| Contains | Determines whether the value parameter occurs within this string, or if value is the empty string, and returns TRUE/FALSE | Contains(text, value) | Contains('Original Text', 'nal') = True |
| Starts_with | Determines whether the beginning of the text matches value parameter and returns TRUE/FALSE | Starts_with(text, value) | Starts_with('Original Text', 'Org') = True |
| Ends_with | Determines whether the end of the text matches value parameter and returns TRUE/FALSE | Ends_with(text, value) | Ends_with('Original Text', 'xt') = True |