Vahana Academy

Upper

The Upper function converts any input string into uppercase letters. It helps ensure uniform text formatting for display, comparison, or data storage. When to Use: Use this function when you want to standardize user input or backend values by converting them to uppercase—especially useful in validations, searches, or ID comparisons. Common Use Cases: Concept You… Continue reading Upper

Date Diff Hours

Introduction This function subtracts one date from another date and returns a numeric value in hours, such as 2 hours, 6 hours, 10 hours, or 15 hours. While calculating the difference between two dates, you can provide static dates, or the DATEDIFFHOURS function can dynamically pick dates from attributes and elements. Use Cases You can use the DATEDIFFHOURS function… Continue reading Date Diff Hours

Date Diff Months

Introduction This function subtracts one date from another date and returns a numeric value in months, such as 2 months, 5 months, 15 months, or 36 months. While calculating the difference between two dates, you can provide static dates, or the DATEDIFFMONTHS function can dynamically pick dates from attributes and elements. Use Cases You can… Continue reading Date Diff Months

Date Diff Years

Introduction This function subtracts one date from another date and returns a numeric value in years, such as 2 years, 5 years, 15 years, or 24 years. While calculating the difference between two dates, you can provide static dates, or the DATEDIFFYEARS function can dynamically pick dates from attributes and elements. Use Cases You can use the DATEDIFFYEARS function… Continue reading Date Diff Years

Months Dif From Now

The MonthsDifFromNow function calculates the number of full months between a given date and the current system date. It helps track the duration of time passed in months, especially useful in workflows involving installment plans, tenure-based validation, or reminders. When to Use Use the MonthDifFromNow function when you need to: This is particularly useful in… Continue reading Months Dif From Now

Years Dif From Now

The YearsDifFromNow function calculates the difference in full years between a given date and the current system date. It is commonly used to determine durations such as age, account tenure, or time passed since a particular event. When to Use Use YearsDifFromNow when you need to: This function is ideal for banking and financial workflows… Continue reading Years Dif From Now

Static

The Static function assigns a constant value—such as a number, string, integer, boolean, or other primitive type—to a field within a workflow. Unlike dynamic values that depend on user input or logic, a static value stays the same unless manually changed. It is commonly used to initialize fields with default or predefined values during form… Continue reading Static

List of vDesigner Functions

FUNCTION NAME FUNCTION NAME FUNCTION NAME FUNCTION NAME FUNCTION NAME AVG SUM PRODUCT DIVIDE POW FACTORIAL SORT ISNULLOREMPTY MAX MIN ISALPHANUMERIC DATEDIFFHOURS FLOOR CONCAT SUBSTR HEX CONTAINS UPPER LOWER ISALPHA CURRENTDATETIME CAST ROUNDUP ROUNDDOWN MOD LOG STATIC CEILING TRUNCATE FORMATNUMBERLOCALIZEDPATTERN ADDMINUTES ADDSECONDS HOUR MINUTES SUBHOURS SUBMINUTES SUBSECONDS WEEKDAY LEFT RIGHT ISNUMERIC TRIM MID CONTAINSALL LEN… Continue reading List of vDesigner Functions