ExpertFlux Wikia
Advertisement
Expression

Informations

Niches

UDs

Tables

UIs

Operators

- (subtraction between <date>-<days> or <date>-<date>)

- (subtraction)

% (rest of entire division)

* (multiplication)

/ (division, with decimal cases)

^ (exponentiation)

+ (addition between <date>-<days>)

+ (concatenation of characters)

+ (sum)

< (comparison: minor)

<= (comparison: minor or equal)

(comparison: equal)

> (comparison: more)

>= (comparison: more or equal)

And (logical operator/ bitwise)

Between (SQL operator)

In (SQL operator)

Like (SQL operator)

Not (logical operator/ bitwise)

Or (logical operator/ bitwise)

Xor (logical operator/ bitwise)

Functions

Function abs

Function ajustaendosso

Function all

Function any

Function asc

Function avg

Function cgccpf

Function char6todate

Function chardateok

Function charrange

Function checkdigit

Function chr

Function cobertname

Function concatlinha

Function convertefaixa

Function count

Function creationdate

Function datamaisdiasuteis

Function date

Function dateadd

Function dateaddyears

Function datenextmonth

Function dateok

Function datesub

Function datetimetojuliandate

Function datetimetostr

Function dateyearsold

Function day

Function daysinyear

Function daysinyear

Function diffmes

Function distinct

Function dsetincount

Function dsetinfield

Function encrypt

Function exists

Function extenso

Function floattostr

Function formatdatetime

Function formatfloat

Function frac

Function getapplicationid

Function getcobertvalue

Function getvfluxdataset

Function gval

Function idade

Function ifeq

Function iif

Function importfield

Function importfieldname

Function incmonth

Function incyear

Function int

Function integer220char2

Function inttostr

Function isleapyear

Function isworkingday

Function juliandatetodatetime

Function lastday

Function left

Function len

Function lowercase

Function itrim

Function moneystring

Function month

Function monthsbetween

Function now

Function nulldefault

Function pos

Function power

Function premioliquido

Function premioliquidoitem

Function premioliquidooriginal

Function questpreenchido

Function replacestring

Function right

Function round

Function rowcount

Function rtrim

Function session

Function sessionexists

Function skcalculadataultimacontribuicao

Function skdiferimento

Function skequalizadataaporte

Function skmax

Function skmin

Function smartround

Function smarttrunc

Function some

Function space

Function sqlmax

Function sqlmin

Function sqrt

Function str

Function strtodate

Function strtoint

Function strtointdef

Function substr

Function sum

Function taskstatus

Function time

Function today

Function trim

Function trunc

Function ultimodiautil

Function upper

Function userhasrole

Function val

Function validateuser

Function year

Batch Modules

Advertisement