# Functions & Expressions

- [Functions and Formulas](/savant-1/analyses/functions-and-expressions/functions-and-formulas.md)
- [Date and Time](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time.md)
- [DATE](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/date.md): Creates a date based on the provided year, month, and day values
- [DATE\_DIFF](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/date_diff.md): Calculates the difference in days, weeks, months, quarters, or years between two dates
- [DATETIME](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/datetime.md): Creates a datetime based on the provided year, month, day, hour, minute, and second values
- [DAY](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/day.md): Retrieves the day of the month from a given date or datetime
- [DAY\_OF\_WEEK](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/day_of_week.md): Determines the day of the week for a given date or datetime, where Monday is 1, Tuesday is 2, and so on
- [DAY\_OF\_YEAR](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/day_of_year.md): Calculates the day of the year for a given date or datetime
- [DAYS\_IN\_MONTH](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/days_in_month.md): Calculates the number of days in the month for a given date or datetime
- [DAYS\_IN\_YEAR](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/days_in_year.md): Calculates the number of days in a year for a given date or datetime, considering leap years
- [HOUR](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/hour.md): Extracts the hour component from a given datetime
- [INTERVAL (Date)](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/interval-date.md): Adds a specified number of days, weeks, months, quarters, or years to a date
- [INTERVAL (DateTime)](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/interval-datetime.md): Adds a specified number of seconds, minutes, or hours to a datetime
- [MINUTE](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/minute.md): Extracts the minute component from a given datetime
- [MONTH](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/month.md): Retrieves the month component from a given date
- [NOW](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/now.md): Retrieves the current date and time
- [QUARTER](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/quarter.md): Retrieves the quarter of the year from a given date or datetime
- [SECOND](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/second.md): Extracts the second component from a given datetime
- [TIME\_PERIOD](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/time_period.md)
- [TIME\_PERIOD\_OFFSET](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/time_period_offset.md): Calculates the number of time periods between a given date and the current period
- [TODAY](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/today.md): Retrieves the current date
- [WEEK/WEEK\_OF\_YEAR](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/week-week_of_year.md): Determines the week number of the year for a given date or datetime
- [YEAR](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/year.md): Retrieves the year component from a given date
- [Text](/savant-1/analyses/functions-and-expressions/functions-and-formulas/text.md)
- [CONCAT](/savant-1/analyses/functions-and-expressions/functions-and-formulas/text/concat.md): Concatenates multiple text strings into a single string
- [ESCAPE\_HTML](/savant-1/analyses/functions-and-expressions/functions-and-formulas/text/escape_html.md): Escapes HTML special characters in a text string
- [HASH](/savant-1/analyses/functions-and-expressions/functions-and-formulas/text/hash.md): Computes the hash value of a text using a specified algorithm (MD5 or SHA-1)
- [LEFT\_SUBSTR](/savant-1/analyses/functions-and-expressions/functions-and-formulas/text/left_substr.md): Retrieves the leftmost characters from a text string
- [LENGTH](/savant-1/analyses/functions-and-expressions/functions-and-formulas/text/length.md): Computes the length (number of characters) of a text string
- [LEVENSHTEIN](/savant-1/analyses/functions-and-expressions/functions-and-formulas/text/levenshtein.md): Measures the edit distance (Levenshtein distance) between two text strings
- [LOWER](/savant-1/analyses/functions-and-expressions/functions-and-formulas/text/lower.md): Converts text to all lowercase characters
- [PROPER](/savant-1/analyses/functions-and-expressions/functions-and-formulas/text/proper.md): Capitalizes the first letter of each word in a text string
- [REGEX\_EXTRACT](/savant-1/analyses/functions-and-expressions/functions-and-formulas/text/regex_extract.md): Extracts text that matches a regular expression pattern
- [REGEX\_MATCH](/savant-1/analyses/functions-and-expressions/functions-and-formulas/text/regex_match.md): Checks if a text string matches a specified regular expression pattern
- [REGEX\_REPLACE](/savant-1/analyses/functions-and-expressions/functions-and-formulas/text/regex_replace.md): Replaces text that matches a regular expression pattern with a specified replacement
- [REGEX\_SEARCH](/savant-1/analyses/functions-and-expressions/functions-and-formulas/text/regex_search.md): Returns the index of the first character of the first matching substring based on a regular expression pattern
- [REPLACE](/savant-1/analyses/functions-and-expressions/functions-and-formulas/text/replace.md): Replaces all occurrences of a specified search string with a replacement string
- [REVERSE](/savant-1/analyses/functions-and-expressions/functions-and-formulas/text/reverse.md): Reverses the order of characters in a text string
- [RIGHT\_SUBSTR](/savant-1/analyses/functions-and-expressions/functions-and-formulas/text/right_substr.md): Extracts the rightmost characters of a text string up to a specified length
- [SEARCH](/savant-1/analyses/functions-and-expressions/functions-and-formulas/text/search.md): Searches for a specific search string within a text and returns the index of the first occurrence
- [SOUNDEX](/savant-1/analyses/functions-and-expressions/functions-and-formulas/text/soundex.md): Converts text to a SOUNDEX code for phonetic matching
- [SPLIT\_PART](/savant-1/analyses/functions-and-expressions/functions-and-formulas/text/split_part.md): Extracts a specific part of a text string using a delimiter
- [SUBSTRING](/savant-1/analyses/functions-and-expressions/functions-and-formulas/text/substring.md): Extracts a portion of a text string starting from a specified position with a given length
- [UNESCAPE\_HTML](/savant-1/analyses/functions-and-expressions/functions-and-formulas/text/unescape_html.md): Converts HTML escape sequences in text back to their original characters
- [UPPER](/savant-1/analyses/functions-and-expressions/functions-and-formulas/text/upper.md): Converts text to all uppercase characters
