All built-in functions are listed here. Click on a function for more information, links will open in a new tab or browser window for convenience.
Aggregate
- AggAvg
- AggCount
- AggDistinctCount
- AggMax
- AggMin
- AggSum
- RunningSum
- AggMedian
- AggMode
- AggStandardDeviation
- AggVariance
Financial
Date
- Date
- DateAdd
- DateCustomFormat
- DateDiff
- DateValue
- Day
- DayOfWeekName
- DayOfWeekNumber
- Days360
- GlobalDateFormat
- GlobalDateTimeFormat
- Hour
- Minute
- Month
- Now
- Second
- Time
- TimeFormat1
- TimeValue
- Today
- Year
- MonthName
- QuarterNumber
- QuarterName
- WeekOfYear
Arithmetic & Geometric
- Absolute
- Acos
- Acosh
- Asin
- Asinh
- Atan
- Atan2
- Atanh
- Ceiling
- Cos
- Cosh
- Even
- Exp
- Fixed
- Floor
- GlobalNumericFormat
- Int
- Ln
- Log
- Log10
- Mod
- Odd
- Pi
- Power
- Product
- Quotient
- Rand
- Round
- Sin
- Sinh
- Sqrt
- Tan
- Tanh
- Truncate
Formatting
String
Operators
& and / concatenate
+ plus
- minus
* multiply
/ divide