xf_GeneralGeneral Functions

Functions to augment the builtin VBA functions.
Like the 'Nz' builtin function, many of these functions have short names because they are used frequently inline in expressions.

Module Sections:

• Comparison, Empty Test and Coercion Functions
• Delimited String Functions - Simple
• General Formatting Functions
• General Text and Numeric Functions
• Person Name and Age Manipulation
• Quoting and Escaping Functions
• Report Filter Date and Formatting Functions
• Type Testing and Conversion
• VBA Collection Related Functions

Alphabetical List of Methods:

• AddIfNotMt(General Formatting Functions)
• AddToControlText(General Formatting Functions)
• AddToStringText(General Formatting Functions)
• AuditTimes(General Formatting Functions)
• BoolFromStr(Type Testing and Conversion)
• BoolToBit(Type Testing and Conversion)
• BoolToStr(Type Testing and Conversion)
• ClearAgeGroupCache(Person Name and Age Manipulation)
• CollectionAddOrUpdate(VBA Collection Related Functions)
• CollectionAsArray(General Formatting Functions)
• CollectionAsDelimList(General Formatting Functions)
• CollectionItemIsObject(VBA Collection Related Functions)
• CollectionTryGetItem(VBA Collection Related Functions)
• ConvertToDate(Comparison, Empty Test and Coercion Functions)
• DateIsEmpty(Report Filter Date and Formatting Functions)
• DateOnly(Type Testing and Conversion)
• DateOnlyVar(Type Testing and Conversion)
• DelimElement(Delimited String Functions - Simple)
• DelimElementCount(Delimited String Functions - Simple)
• DelimListAdd(Delimited String Functions - Simple)
• DelimListAddRtn(Delimited String Functions - Simple)
• DelimListMemberIndex(Delimited String Functions - Simple)
• DelimListQuoteElements(Delimited String Functions - Simple)
• DelimListRemoveMember(Delimited String Functions - Simple)
• DelimListUnquoteElements(Delimited String Functions - Simple)
• DisplayFileSize(General Formatting Functions)
• DisplayHrMin(General Formatting Functions)
• dq(Quoting and Escaping Functions)
• FindIntInArray(General Formatting Functions)
• FormatName(Person Name and Age Manipulation)
• GetAge(Person Name and Age Manipulation)
• GetAgeGroup(Person Name and Age Manipulation)
• GetAgeInt(Person Name and Age Manipulation)
• GetFirstName(Person Name and Age Manipulation)
• GetLastName(Person Name and Age Manipulation)
• GetTimeAgo(General Formatting Functions)
• GetXfComparisonType(Comparison, Empty Test and Coercion Functions)
• IntInParamList(General Formatting Functions)
• IsInteger(Type Testing and Conversion)
• IsValidBool(Type Testing and Conversion)
• IsWeekend(Type Testing and Conversion)
• IsZeroAmt(Report Filter Date and Formatting Functions)
• KeyInDictionary(VBA Collection Related Functions)
• LongestString(General Text and Numeric Functions)
• MakeTextVertical(General Formatting Functions)
• MaxValue(General Text and Numeric Functions)
• MinValue(General Text and Numeric Functions)
• mt(Comparison, Empty Test and Coercion Functions)
• mt_or_0(Comparison, Empty Test and Coercion Functions)
• mt_or_val(Comparison, Empty Test and Coercion Functions)
• NumberWithSuffix(General Formatting Functions)
• nze(Comparison, Empty Test and Coercion Functions)
• nze0(Comparison, Empty Test and Coercion Functions)
• q(Quoting and Escaping Functions)
• QuoteByQuoteType(Quoting and Escaping Functions)
• QuoteWithEscape(Quoting and Escaping Functions)
• RemoveDateFormatting(Quoting and Escaping Functions)
• RoundCur(Report Filter Date and Formatting Functions)
• RoundDbl(Report Filter Date and Formatting Functions)
• SqBr(Quoting and Escaping Functions)
• StripSquareBrackets(Quoting and Escaping Functions)
• subst(General Formatting Functions)
• subst_array(General Formatting Functions)
• TimeOnly(Type Testing and Conversion)
• TimeOnlyVar(Type Testing and Conversion)
• Unquote(Quoting and Escaping Functions)
• WaitForTime(General Text and Numeric Functions)
• zn(Report Filter Date and Formatting Functions)