The following table contains functions that can be used within the Filter Editor. Some of these functions may be accessible within the **Visual **view, but most are available when editing filters with the **Text **view.

Function Name | Description |
---|---|

Abs | Returns the absolute value of a specified numeric operand. |

Acos | Returns the angle (in radians) whose cosine is a specified numeric operand. |

AddDays | Returns a DateTime object representing the date that is a specified number of days from a specific date. The operands should be defined as follows: 1 - a DateTime object representing the original date; 2 - the time period (in days) from the original date. This number can be negative or positive. It's decimal part is part of a day. |

AddHours | Returns a DateTime object representing the date that is a specified number of hours from a specific date. The operands should be defined as follows: 1 - a DateTime object representing the original date; 2 - the time period (in hours) from the original date. This number can be negative or positive. It's decimal part is part of an hour. |

AddMilliSeconds | Returns a DateTime object representing the date that is a specified number of milliseconds from a specific date. The operands should be defined as follows: 1 - a DateTime object representing the original date; 2 - the time period (in milliseconds) from the original date. This number can be negative or positive. It's decimal part is part of a millisecond. |

AddMinutes | Returns a DateTime object representing the date that is a specified number of minutes from a specific date. The operands should be defined as follows: 1 - a DateTime object representing the original date; 2 - the time period (in minutes) from the original date. This number can be negative or positive. It's decimal part is part of a minute. |

AddMonths | Returns a DateTime object representing the date that is a specified number of months from a specific date. The operands should be defined as follows: 1 - a DateTime object representing the original date; 2 - the time period (in months) from the original date. This number can be negative or positive. |

AddSeconds | Returns a DateTime object representing the date that is a specified number of seconds from a specific date. The operands should be defined as follows: 1 - a DateTime object representing the original date; 2 - the time period (in seconds) from the original date. This number can be negative or positive. It's decimal part is part of a second. |

AddTicks | Returns a DateTime object representing the date that is a specified number of ticks from a specific date. The operands should be defined as follows: 1 - a DateTime object representing the original date; 2 - the time period (in 100-nanosecond ticks) from the original date. This number can be negative or positive. |

AddTimeSpan | Returns a DateTime object representing the date that is a specified time period from a specific date. The operands should be defined as follows: 1 - a DateTime object representing the original date; 2 - a TimeSpan object representing the time period from the original date. |

AddYears | Returns a DateTime object representing the date that is a specified number of years from a specific date. The operands should be defined as follows: 1 - a DateTime object representing the original date; 2 - the time period (in years) from the original date. This number can be negative or positive. |

Ascii | Returns the ASCII code of the first character in a specified string operand. If a specified operand represents an empty string, null is returned. |

Asin | Returns the angle (in radians) whose sine is a specified numeric operand. |

Atn | Returns the angle (in radians) whose tangent is a specified numeric operand. |

Atn2 | Returns the angle (in radians) whose tangent is the quotient of two specified numeric operands. The operator requires two operands representing the Cartesian coordinates ( x, y) of a point:1 - the y coordinate;2 - the x coordinate. |

BigMul | Calculates the product of two specified numeric operands. The operator requires two operands representing the integer values to be multiplied. |

Ceiling | Returns the smallest integer greater than or equal to a specified numeric operand. The rounding provided by this operator is called rounding toward positive infinity. |

Char | Converts a specified numeric operand to a Unicode character. |

CharIndex | Returns the index of the first occurrence of a specified substring in a specified string. The operands should be defined as follows: 1 - a substring to search for; 2 - a string to be searched in; 3 - (optional) an integer that specifies the zero-based index at which the search starts. If this operand is not specified, the search begins from the start of the string; 4 - (optional) an integer that specifies the number of characters to examine, starting from the specified position. If this operand is not specified, the search continues until the end of the string. This function performs a word (case-sensitive and culture-sensitive) search using the current culture. If a specified substring is found, the function returns its index. Otherwise, -1 is returned. |

Concat | Concatenates one or more strings. |

Contains | Returns True if one string occurs within another string; otherwise, False is returned. This function requires two string operands: 1 - a string to be searched; 2 - a substring to search. |

Cos | Returns the cosine of a specified numeric operand representing an angle, measured in radians. |

Cosh | Returns the hyperbolic cosine of a specified numeric operand representing an angle, measured in radians. |

DateDiffDay | Returns the count of day boundaries crossed between the specified starting date and ending date. The operands should be defined as follows: 1 - a DateTime object representing the starting date; 2 - a DateTime object representing the ending date. |

DateDiffHour | Returns the count of hour boundaries crossed between the specified starting date and ending date. The operands should be defined as follows: 1 - a DateTime object representing the starting date; 2 - a DateTime object representing the ending date. |

DateDiffMilliSecond | Returns the count of millisecond boundaries crossed between the specified starting date and ending date. The operands should be defined as follows: 1 - a DateTime object representing the starting date; 2 - a DateTime object representing the ending date. |

DateDiffMinute | Returns the count of minute boundaries crossed between the specified starting date and ending date. The operands should be defined as follows: 1 - a DateTime object representing the starting date; 2 - a DateTime object representing the ending date. |

DateDiffMonth | Returns the count of month boundaries crossed between the specified starting date and ending date. The operands should be defined as follows: 1 - a DateTime object representing the starting date; 2 - a DateTime object representing the ending date. |

DateDiffSecond | Returns the count of second boundaries crossed between the specified starting date and ending date. The operands should be defined as follows: 1 - a DateTime object representing the starting date; 2 - a DateTime object representing the ending date. |

DateDiffTick | Returns the count of tick boundaries crossed between the specified starting date and ending date. The operands should be defined as follows: 1 - a DateTime object representing the starting date; 2 - a DateTime object representing the ending date. |

DateDiffYear | Returns the count of year boundaries crossed between the specified starting date and ending date. The operands should be defined as follows: 1 - a DateTime object representing the starting date; 2 - a DateTime object representing the ending date. |

EndsWith | Returns True if the end of one string matches another string; otherwise, False is returned. This function requires two string operands: 1 - a string to be searched; 2 - a substring to search at the end of the first string. |

Exp | Returns the number e raised to the power specified by a numeric operand. |

Floor | Returns the largest integer less than or equal to a specified numeric operand. The rounding provided by this operator is called rounding toward negative infinity. |

GetDate | Returns the date part of a specified date. This operator requires an operand of the DateTime type. The return value represents a DateTime object with the same date part, and the time part set to 00:00:00. |

GetDay | Gets the day part of a specified date. This operator requires an operand of the DateTime type. The return value ranges between 1 and 31. |

GetDayOfWeek | Gets a specified date's day of the week. This operator requires an operand of the DateTime type. |

GetDayOfYear | Gets a specified date's day of the year. This operator requires an operand of the DateTime type. The return value ranges between 1 and 366. |

GetHour | Gets the hour part of a specified date. This operator requires an operand of the DateTime type. The return value ranges between 0 and 23. |

GetMilliSecond | Gets the milliseconds part of a specified date. This operator requires an operand of the DateTime type. The return value ranges between 0 and 999. |

GetMinute | Gets the minute part of a specified date. This operator requires an operand of the DateTime type. The return value ranges between 0 and 59. |

GetMonth | Gets the month part of a specified date. This operator requires an operand of the DateTime type. The return value ranges between 1 and 12. |

GetSecond | Gets the seconds part of a specified date. This operator requires an operand of the DateTime type. The return value ranges between 0 and 59. |

GetTimeOfDay | Gets the time part of a specified date. This operator requires an operand of the DateTime type. The return value represents an Int64 object that is equal to the number of 100-nanosecond ticks that have elapsed since midnight. |

GetYear | Gets the year part of a specified date. This operator requires an operand of the DateTime type. The return value ranges between 1 and 9999. |

Iif | Returns one of several specified values depending upon the values of logical expressions. The function can take 2N+1 arguments (N - the number of specified logical expressions):- Each odd argument specifies a logical expression;
- Each even argument specifies the value that is returned if the previous expression evaluates to
**true**.
Examples: IifIif |

Insert | Inserts a specified string at a certain position within another. The operands should be defined as follows: 1 - a string in which the insertion is to be performed; 2 - an integer that specifies the zero-based index position of the insertion; 3 - a string to insert. |

IsApril | Returns True if the specified date falls within April. |

IsAugust | Returns True if the specified date falls within August. |

IsDaysFromToday | Returns True if the calculated date is today after adding the number of days to the specified date. The operands should be defined as follows: 1 - a DateTime object representing the original date; 2 - the number of days to offset the original date. This number can be negative or positive. |

IsGreaterThanDaysFromToday | Returns True if the calculated date is greater than today after adding the number of days to the specified date. The operands should be defined as follows: 1 - a DateTime object representing the original date; 2 - the number of days to offset the original date. This number can be negative or positive. |

IsLessThanDaysFromToday | Returns True if the calculated date is less than today after adding the number of days to the specified date. The operands should be defined as follows: 1 - a DateTime object representing the original date; 2 - the number of days to offset the original date. This number can be negative or positive. |

IsDecember | Returns True if the specified date falls within December. |

IsFebruary | Returns True if the specified date falls within February. |

IsJanuary | Returns True if the specified date falls within January. |

IsJuly | Returns True if the specified date falls within July. |

IsJune | Returns True if the specified date falls within June. |

IsLastMonth | Returns True if the specified date falls within the previous month. |

IsLastYear | Returns True if the specified date falls within the previous year. |

IsMarch | Returns True if the specified date falls within March. |

IsMay | Returns True if the specified date falls within May. |

IsNextMonth | Returns True if the specified date falls within the next month. |

IsNextYear | Returns True if the specified date falls within the next year. |

IsNovember | Returns True if the specified date falls within November. |

IsNull | Compares the first operand with the NULL value. The value returned depends upon the number of arguments. If a single operand is passed, the function returns true if the operand is null, otherwise, false is returned.If two operands are passed, the function returns the second operand if the first operand is null, otherwise, the first operand is returned. |

IsNullOrEmpty | Indicates whether a specified operand is a null reference or an empty string. The function returns true if a specified operand is null or an empty string, otherwise, false is returned. |

IsOctober | Returns True if the specified date falls within October. |

IsOutlookIntervalBeyondThisYear | The Boolean Is Beyond This Year operator for date/time values. Requires one argument. The operator is defined as follows: date >= First Day of Next Year |

IsOutlookIntervalEarlierThisMonth | The Boolean Is Earlier This Month operator for date/time values. Requires one argument. The operator is defined as follows: First Day of This Month <= date < First Day of Last Week |

IsOutlookIntervalEarlierThisWeek | The Boolean Is Earlier This Week operator for date/time values. Requires one argument. The operator is defined as follows: First Day of This Week <= date < Yesterday |

IsOutlookIntervalEarlierThisYear | The Boolean Is Earlier This Year operator for date/time values. Requires one argument. The operator is defined as follows: First Day of This Year <= date < First Day of This Month |

IsOutlookIntervalLastWeek | The Boolean Is Last Week operator for date/time values. Requires one argument. The operator is defined as follows: First Day of Last Week <= date < First Day of This Week |

IsOutlookIntervalLaterThisMonth | The Boolean Is Later This Month operator for date/time values. Requires one argument. The operator is defined as follows: Last Day of Next Week < date < First Day of Next Month |

IsOutlookIntervalLaterThisWeek | The Boolean Is Later This Week operator for date/time values. Requires one argument. The operator is defined as follows: Day After Tomorrow <= date < First Day of Next Week |

IsOutlookIntervalLaterThisYear | The Boolean Is Later This Year operator for date/time values. Requires one argument. The operator is defined as follows: First Day of Next Month <= date < First Day of Next Year |

IsOutlookIntervalNextWeek | The Boolean Is Next Week operator for date/time values. Requires one argument. The operator is defined as follows: First Day of Next Week <= date <= Last Day of Next Week |

IsOutlookIntervalPriorThisYear | The Boolean Is Prior This Year operator for date/time values. Requires one argument. The operator is defined as follows: date < First Day of This Year |

IsOutlookIntervalToday | The Boolean Is Today operator for date/time values. Requires one argument. |

IsOutlookIntervalTomorrow | The Boolean Is Tomorrow operator for date/time values. Requires one argument. |

IsOutlookIntervalYesterday | The Boolean Is Yesterday operator for date/time values. Requires one argument. |

IsSameDay | Returns True if the specified date/time values fall within the same day. |

IsSeptember | Returns True if the specified date falls within September. |

IsThisMonth | Returns True if the specified date falls within the current month. |

IsThisWeek | Returns True if the specified date falls within the current week. |

IsThisYear | Returns True if the specified date falls within the current year. |

IsYearToDate | Returns True if the specified date falls within the year-to-date period. This period starts from the first day of the current year and continues up to the current date (including this current date). |

Len | Returns the length of the string specified by an operand. |

LocalDateTimeDayAfterTomorrow | Returns the DateTime value corresponding to the day after Tomorrow. |

LocalDateTimeLastMonth | Returns the DateTime value corresponding to the first day of the previous month. |

LocalDateTimeLastWeek | Returns the DateTime value corresponding to the first day of the previous week. |

LocalDateTimeLastYear | Returns the DateTime value corresponding to the first day of the previous year. |

LocalDateTimeNextMonth | Returns the DateTime value corresponding to the first day of next month. |

LocalDateTimeNextWeek | Returns the DateTime value corresponding to the first day of the following week. |

LocalDateTimeNextYear | Returns the DateTime value corresponding to the first day of the following year. |

LocalDateTimeNow | Returns the DateTime value corresponding to the current moment in time. |

LocalDateTimeThisMonth | Returns the DateTime value corresponding to the first day of the current month. |

LocalDateTimeThisWeek | Returns the DateTime value corresponding to the first day of the current week. |

LocalDateTimeThisYear | Returns the DateTime value corresponding to the first day of the current year. |

LocalDateTimeToday | Returns the DateTime value corresponding to Today. |

LocalDateTimeTomorrow | Returns the DateTime value corresponding to Tomorrow. |

LocalDateTimeTwoMonthsAway | Returns the DateTime value corresponding to the first day of the month after next. |

LocalDateTimeTwoWeeksAway | Returns the DateTime value corresponding to the first day of the week after next. |

LocalDateTimeTwoYearsAway | Returns the DateTime value corresponding to the first day of the year after next. |

LocalDateTimeYearBeforeToday | Returns the DateTime value corresponding to the day one year ago. |

LocalDateTimeYesterday | Returns the DateTime value corresponding to Yesterday. |

Log | Returns the logarithm of a specified numeric operand. The return value depends upon the number of operands. If one operand is passed, the natural (base e) logarithm of a specified operand is returned.If two operands are passed, the logarithm of a specified operand in a specified base is returned. The operands should be defined as follows: 1 - a number whose logarithm is to be calculated; 2 - the base of the logarithm. |

Log10 | Returns the base 10 logarithm of a specified numeric operand. |

Lower | Converts all characters in a string operand to lowercase. |

Max | Returns the larger of two numeric values. The operands should be defined as follows: 1 - a numeric value A; 2 - a numeric value B; |

Min | Returns the smaller of two numeric values. The operands should be defined as follows: 1 - a numeric value A; 2 - a numeric value B; |

None | The function type is not specified. |

Now | Returns a DateTime object representing the system's current date and time. |

PadLeft | Pads a string with spaces or a specified Unicode character on the left for a specified total length. The operands should be defined as follows: 1 - a string to be padded; 2 - the total number of characters in the resulting string, including padding characters; 3 - (optional) a Unicode padding character. If not specified, the space character is used for padding. If a string is passed as this operand, its first character is used for padding. |

PadRight | Pads a string with spaces or a specified Unicode character on the right for a specified total length. The operands should be defined as follows: 1 - a string to be padded; 2 - the total number of characters in the resulting string, including padding characters; 3 - (optional) a Unicode padding character. If not specified, the space character is used for padding. If a string is passed as this operand, its first character is used for padding. |

Power | Returns a specified numeric operand raised to a specific power. The Power operator requires two operands:1 - a number to be raised to a power; 2 - a power. |

Remove | Removes all, or a certain number of characters from a specified string, starting at a specified position. The operands should be defined as follows: 1 - a string to be shrunk; 2 - an integer that specifies the zero-based index at which character removal starts; 3 - (optional) an integer that specifies the number of characters to remove, starting at the specified position. If this operand is not specified, all characters between the starting position and the end of the string are removed. |

Replace | Replaces all occurrences of a certain string in a specified string, with another. The operands should be defined as follows: 1 - a string in which replacements are to be performed; 2 - a string to be replaced; 3 - a string to replace all occurrences found. |

Reverse | Reverses the order of characters within a specified string. |

Rnd | Returns a random number greater than or equal to 0. |

Round | Rounds a specified numeric operand to the nearest integer or to a specified number of decimal places. The rounding provided by this operator is called rounding to nearest or banker's rounding. The operands should be defined as follows: 1 - a value to round; 2 - (optional) a value specifying the number of decimal places to round to. 0 indicates that the first operand is rounded to the nearest integer. |

Sign | Returns a value indicating the sign of a number represented by a specified operand. The function returns one of the following values: 1, for positive numbers; -1, for negative numbers; 0, if the number is equal to zero. |

Sin | Returns the sine of a specified numeric operand representing an angle, measured in radians. |

Sinh | Returns the hyperbolic sine of a specified numeric operand representing an angle, measured in radians. |

Sqr | Returns the square root of a specified numeric operand. |

StartsWith | Returns True if the beginning of one string matches another string; otherwise, False is returned. This function requires two string operands: 1 - a string to be searched; 2 - a substring to search at the beginning of the first string. |

Substring | Returns a substring extracted from the specified string. If two operands are passed the substring will be extracted from the beginning of the original string. The operands should be defined as follows: 1 - an original string; 2 - an integer that specifies the zero-based index at which the substring to return begins. If three operands are passed a substring can be subtracted starting from any position in the original string. The operands should be defined as follows: 1 - an original string; 2 - an integer that specifies the zero-based index at which the substring to return begins; 3 - an integer that specifies the length of the substring. |

Tan | Returns the tangent of a specified numeric operand representing an angle, measured in radians. |

Tanh | Returns the hyperbolic tangent of a specified numeric operand representing an angle, measured in radians. |

ToDecimal | Converts a numeric operand to a fixed-point (exact-value) representation. |

ToDouble | Converts a numeric operand to a double-precision floating-point (approximate-value) representation. |

ToFloat | Converts a numeric operand to a floating-point (approximate-value) representation. |

ToInt | Converts a numeric operand to an integer representation. |

ToLong | Converts a numeric operand to a long integer representation. |

ToStr | Returns a string representation of a specified numeric operand. |

Today | Returns a DateTime object representing the system's current date. The object's time part is set to 00:00:00. |

Trim | Returns a string containing a copy of a specified string with no leading nor trailing spaces. |

Upper | Converts all characters in a string operand to uppercase. |

UtcNow | Returns a DateTime object representing the current Coordinated Universal Time (UTC) date and time. |

Help Desk Software Powered by SmarterTrack

© 2003-2020 SmarterTools Inc.