# Tips

To add any variable in the function defintion you need to add a Dollar($) Sign before it.

SUM($price, $tax) ✅

SUM(price, tax) ❌Name of all the functions should in Upper Case.

SUM(2,4) ✅

Sum(2,4) ❌

# Date & Time Functions

**NOW()**– Returns the current date and time as a date value. You can use this date value in other date functions. E.g. 11/2/2021, 7:07:20 AM. You can also use NOW() function to return timestamp of your time zone. Eg. NOW(‘Asia/Kolkata’), NOW(‘America/Detroit’).**WEEKDAY(date)**– Returns a number representing the day of the week of the date provided. Eg. WEEKDAY(NOW()) – This will show 2 on the preview.**YEAR(date)**– Returns the year specified by a given date. E.g. YEAR($DateVariable) – This is show the year corresponding to the date entered by the user in Crove Forms or passed to the variable using any Crove Integration.**MONTH(date)**– Returns the month of the year a specific date falls in, in numeric format.**HOURS(time)**– Returns the hour component of a specific time, in numeric format. E.g. HOURS(NOW()) will show “7”. (example continued from the first function defintion)**MINUTES(time)**– Returns the minute component of a specific time, in numeric format.**SECONDS(time)**– Returns the second component of a specific time, in numeric format.**TODAY()**– Returns today’s date in DD/MM/YYYY format.

# Currency Functions

**CURRENCYINNUMBERS(number,locale)**– Converts a number into currency (Locale – “INR”/”USD”). This function rounds off the currency to 2 digits after the decimal. E.g. CURRENCY**CURRENCYINWORDS(number,locale)**– Converts a number into currency in words. (Locale – “INR”/”USD”)

# Math Functions

**SUM(value1, value2,….)**– Returns the sum of a series of numbers.**MINUS(value1, value2)**– Returns the difference of two numbers. Equivalent to the `-` operator.**MULTIPLY(value1, value2,….)**– Returns the multiplication of a series of numbers.**DIVIDE(value1, value2)**– Returns the result of division two numbers.**AVERAGE(value1, value2,….)**– Returns the numerical average value in a dataset, ignoring text.**ROUND(value, scale)**– Rounds a number to a certain number of decimal places according to standard rules. E.g. ROUND(34.7899,2) will be converted to 34.79

# String Functions

**CONCAT(value1,value2,….)**– Returns the concatenation of two or more values. E.g. CONCATENATE(“Hello”,”World!”) will show the be converted to*HelloWorld!***ISBLANK(value)**– Checks whether the referenced variable is empty.**ISEMAIL(value)**– Checks whether a value is a valid email address.**LOWER(text)**– Converts a specified string to lowercase.**UPPER(text)**– Converts a specified string to uppercase.**REPLACEALL(text, pattern, new_text)**– Replaces all occurences of the given text. REPLACEALL(“here here here”,”here”,”there”) this will be changed to*there there there***REPLACE(text, pattern, new_text)**– Replaces only the first occurence of the given text. REPLACE(“here here here”,”here”,”there”) this will be changed to*there here here***ROMAN(number)**– Formats a number in Roman numerals.