If Then Else

The If - Then - Else construct can be used to make conditional parts in an expression.

Constructs can be "nested", just as long as each "nesting" has a block of matching If, Then and Else.

The Choose construct can be used as an alternative when multiple conditions need to be checked: in many cases the Choose construct will be easier to read and understand.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Syntax
/* basic construction */
IF boolean_condition 
THEN value
ELSE value

/* extended construction */
IF boolean_condition THEN value
ELSE if boolean_condition THEN value
ELSE if boolean_condition THEN value
ELSE if boolean_condition THEN value
ELSE value

/* Examples: */
IF DayOfWeek ([Webshop.Orders.OrderDate]) = 1 
THEN "Monday"
ELSE "Not monday"

IF DayOfWeek ([Webshop.Orders.OrderDate]) = 2 
    THEN "Tuesday"
ELSE IF DayOfWeek ([Webshop.Orders.OrderDate]) = 3 
    THEN "Wednesday"
ELSE IF DayOfWeek ([Webshop.Orders.OrderDate]) = 4 
    THEN "Thursday"
ELSE IF DayOfWeek ([Webshop.Orders.OrderDate]) = 5 
    THEN "Friday"
ELSE IF DayOfWeek ([Webshop.Orders.OrderDate]) = 6 
    THEN "Saturday"
ELSE IF DayOfWeek ([Webshop.Orders.OrderDate]) = 7 
    THEN "Sunday"
ELSE "Monday"

Last updated

Was this helpful?