Visual Basic for Applications functions

The following Visual Basic for Applications functions can be used in data shaping CALC expressions:

Abs
Asc
Atn
CBool
CByte
CCur
CDate
CDbl
Chr
ChrB
ChrW
Chr$
ChrB$
CInt
CLng
Cos
CSng
CStr
Cvar

CVDate
CVErr
Date
Date$
DateAdd
DateDiff
DatePart
DateSerial
DateValue
Day
DDB
Error
Error$
Exp
Fix
Format
Format$
FV
Hex

Hex$
Hour
IIF
InStr
Int
IPmt
IRR
IsDate
IsEmpty
IsError
IsNull
IsNumeric
IsObject
LCase
LCase$
Left
LeftB
Left$
LeftB$

Len
Log
LTrim
LTrim$
Mid
Mid$
Minute
MIRR
Month
Now
NPer
NPV
Oct
Oct$
Pmt
PPmt
PV
QBColor
Rate

RGB
Right
RightB
Right$
RightB$
Rnd
RTrim
RTrim$
Second
Sgn
Sin
SLN
Space
Space$
Sqr
Str
Str$
StrComp
StrConv

String
String$
SYD
Tan
Time
Time$
Timer
TimeSerial
TimeValue
Trim
Trim$
TypeName
UCase
UCase$
Val
VarType
Weekday
Year

See Also

Accessing Rows in a Hierarchical Recordset
Data Shaping Overview
Formal Shape Grammar
Required Providers for Data Shaping
Shape APPEND Clause
Shape Commands in General
Shape COMPUTE Clause