Initial form field value available functions

unknown

Hi,

    I'm figuring out how to find a list of available function that I can use in a session field filling the "Initial form field value" in LN Studio.

In the past I used fmax($#) (to fill the filed with the max available domain value) and utc() (to fill a tcdate field with the current datetime).

The LN Studio guide and the standard LN developer guide does not specify anything.

In the past I remember I found a list of functions using Google, but maybe from baanboard forum.

Could someone help me? I'm searching the utc() variant that fills out a days only date field (the equivalent of date.num()).

Thank you,

Michele

unknown

Found in expr.compile() features section:

The following functions:

abs() acos() asc() asin() atan() chr() cos()
cosh() edit() exp() int() len() log() log10()
min() max() pos() pow() round() rpos() sin()
sqrt() str() strip() tan() tanh() val()

time()
current time in HHMM format

date()
current date in number of days since January 1,0001

date(YYYY,MM,DD)
specified date in number of days since January 1, 0001

for example: date() IN [ date(1988,1,1), date(1992,1,1) ]

utc()
current date and time in UTC long format

utc(YYYY,MM,DD,HH,MM,SS)
specified local date/time in UTC long format;input values must be in signed 32-bit value range;if exact result is negative or greater thanthe maximum value2^( BitCountOfLong-1) - 1of the signed BitCountOfLong-bitrange,then error value -1 is returned

fmin()
Returns the minimum value of a 4GL variable, domain, ortable field. See set.fmin() for an explanation of how the attributes of theconcerned domain may influence the result.

fmax()
Returns the maximum value of a 4GL variable, domain, ortable field. See set.fmax() for an explanation of how the attributes of theconcerned domain may influence the result.