The syntax for a function call is simple, and is the same whether you are calling one of the built-in functions or one of the user-defined functions at the top of your macro.

 

In all cases, use the function name followed by a list of expressions, separated by commas, of data type corresponding to the function prototype.

Today() // no parameters
GetEasterFor(nYear) // one parameter

The result of a function call can either be assigned to a variable

nToday = Today()
nDateEaster = GetEasterFor(nYear)

or it can be used as parameter of another function call, as below, in nested function calls.

nWeekDay = WeekdayOf(Today())
nMayFirst = FirstDateOfMonth(YearOf(Today()),5)

Void Functions

 

Some functions are called void, because they do not return any result. These are usually function that act on the database or on the textbox that contains the current macro token. They are called simply, without assigning their result.

Reset_FindNextHolidayOnDate()
SetBoxTop(25952256)

To find out which functions are available to you, and how to use them, you can either look up the built-in functions section below, or from within the code editor press F3 to invoke code completion.

 

See also: list of all macro functions.

 

---

Topic 105130, last updated on 18-Apr-2020