Functions Reference : : Knowledge Base

Functions Reference

Type
Arithmetic Operators	+ (addition)	- (subtraction)	* (multiplication)	/ (division)
	\ (integer division)	% (remainder)	^ (exponentiation)	: (time operator)

Comparison Operators	< (less than)	> (greater than)	= (equal to)	<> (not equal to)
	<= (less than or equal to)	>= (greater than or equal to)

Logical Operators	OR	XOR (one or the other)	AND

Array Operators	IN	NIN (not in)

Control Functions	if()	switch()	choose()

String Functions	left()	right()	mid()	instr()
	instr2()	val()	len()	lcase()
	ucase()	trim()	string()	replace()
	reduceChars()	removeAccents()	chr()	asc()
	ordinal()	similarity()	CorrectSpelling()	stringCount()
	SplitString()

Mathematical Functions	int()	sqrt()	quersumme()	abs()
	round()	speed()	pace()

Result Functions	TCount()	TCountIf()	TSum()	TRSum()
	TMin()	TRMin()	TMinID()	TMinName()
	TAvg()	TRAvg()	TMax()	TRMax()
	TMaxID()	TMaxName()	TFirst()	TRFirst()
	TFirstName()	TFirstID()	TLast()	TRLast()
	TLastID()	TLastName()	T()	TR()
	TName()	TText()	TPrev()	DMaxMin()
	TMinIf()	TMaxIf()	TMinIfID()	TMaxIfID()

Conversion Functions	urlencode()	NumberToWords()	ZahlInWort()	TimeFromString()
	md5()	crc7()

Time and Date Functions	format()	date()	now()	ElapsedTime()
	AgeOnDate()

Check Functions	inRange()	isNumeric()	isAlpha()	hasChip()
	search()	isUCICode()	isUCIID()	hasEntryFee(entryFeeID)
	isEligible()	isValidEmail()

Inter-Record Functions	BunchTime()	GapTimeTop()	GapTimePrev()	TeamGapTimeTop()
	TeamGapTimePrev()	DCount()	DSum()	DMin()
	DAvg()	DMax()	DFirst()	DLast()
	DConcat()	DQuantile()	DCountDistinct()

Other Functions	nz()	min()	max()	first()
	last()	table()	Setting()	GetSex()
	translate()	rank(x)	Text()	ChangeLink()

Scoring Functions	AgeGradedOC2015()	AgeGradedLevel2015()	AgeGradedFactor2015()
	AgeGradedOC2020()	AgeGradedLevel2020()	AgeGradedFactor2020()

Cookie	LastUser
Description	Stores the customer number from the last login through this browser. Used to prefill the user input in the login area.

Cookie	Cookieconsent
Description	Used to check if the cookie banner was shown to you in the last 35 days. Also stores your specific cookie banner selections.

Cookie	contactform_flag
Description	Checks if the red box with the contact form hint has already been presented in this browser session.checks if the red box with the contactform hint has already been presented in this browser session

Cookie	PHPSESSID
Description	This key is necessary to anonymously identify the current user session by our system. Essential for shopping cart, order process, customer account, etc.This key is necessary to anonoumously identify the current user session by our system. Essential for shopping cart, order process, customer account etc.

Cookie	Vimeo
Description	We use the video platform Vimeo to host videos and embed them into our website. When clicking on the video, Vimeo may set cookies in the browser.

Cookie	analytics_storage
Description	Checks if Google Analytics cookies can be stored to analyze user behavior on the website and understand how visitors interact with our content. By consenting, you help us improve the user experience.

Cookie	ad_storage
Description	Checks if advertising cookies can be stored, which are used for personalized advertising and retargeting.

Cookie	ad_personalization
Description	Controls whether ads are personalized based on the user's behavior and interests to show tailored ads.

Cookie	ad_user_data
Description	Controls whether the user's personal data can be processed for advertising purposes, such as information about age, gender, or interests.

Contact us!