Functions Reference

Contents
Chapter 1
Introduction 11
About functions 11
Using this functions reference 11
Functions reference (alphabetical list) 12
Chapter 2
Aggregate functions 17
Average 18
Count 19
List 20
Max 21
Min 22
StDev 23
StDevP 25
Sum 26
Variance 27
VarianceP 28
Chapter 3
Date functions 31
Date 32
Day 32
DayName 33
DayNameJ 34
DayOfWeek 34
DayOfYear 35
Month 35
MonthName 36
MonthNameJ 36
WeekOfYear 37
WeekOfYearFiscal 37
Year 38
YearName 39
Chapter 4
Design functions 41
DatabaseNames 43
FieldBounds 43
FieldComment 44