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 Summary | Formal Shape Grammar | Required Providers for Data Shaping | Shape APPEND Clause | Shape Commands in General | Shape COMPUTE Clause