Developer features

Expression Functions

Flare has an extensive list of expression functions, making it easy to build both simple and complex expressions. Below is a partial list.

Date & Time Functions

32 shown
DateFormatDateOnlyDayDayOfWeekDaysInMonthHourHour24MakeDateMilliSecondsMinuteMonthLongNameMonthNumberMonthShortNameNowParseDateParseDateExactQuarterNumberSecondsTodayTotalDaysTotalMinutesTotalSecondsWeekOfYearWorkDaysInMonthYearAddDaysAddHoursAddMinutesAddMonthsAddSecondsAddYearsAMPM

Filter Functions

17 shown
WhereWhereBetweenWhereEQWhereGTWhereGEWhereLTWhereLEWhereLikeWhereNotLikeSelectAllSelectCurrentSelectNoneClearAllAndFilterOrFilterNotFilterMinusFilter

String Functions

11 shown
IndexOfLastIndexOfLeftLenLowerCaseReplaceSubStringTrimTrimStartTrimEndUpperCase

Math Functions

10 shown
AbsCeilingFloorMaxValueMinValueRoundFmodRandomHash256Hash512

General Functions

10 shown
AppNameChrIsNullNullIsNumIsTextIsSingleValueReloadDateSleepUser

Aggregate Functions

7 shown
AvgCountMinMaxSumRankSubQuery

Color Functions

5 shown
ARGBRGBHSLHSLAGetGradientColor

Type Conversion Functions

4 shown
ToDateTimeToDoubleToIntegerToString

Chart-Only Functions

4 shown
GetColumnGetColumnPreviousGetDimensionCountRank

Load Script-Only Functions

4 shown
WriteLineRowIDExistsNotExists
See it live

Expressions do the heavy lifting

From a simple Sum to conditional, variable-driven logic — book a demo and see expressions at work on your own data.

Request a demo