The choose, when, then, default and endkeywords add a condition to an expression.

Syntax

choose
	when boolean_condition then value
	when boolean_condition then value
	when boolean_condition then value
	when boolean_condition then value
	when boolean_condition then value
	default value
end

Returns

The value after the then of the first condition that returns true. If all conditions return false, then the value after default is returned. Don’t forget the end keyword.

Example

choose<br> when DayOfWeek ([Webshop.Orders.OrderDate]) = 1 Then "Monday"<br> when DayOfWeek ([Webshop.Orders.OrderDate]) = 2 Then "Tuesday"<br> when DayOfWeek ([Webshop.Orders.OrderDate]) = 3 Then "Wednesday"<br> when DayOfWeek ([Webshop.Orders.OrderDate]) = 4 Then "Thursday"<br> when DayOfWeek ([Webshop.Orders.OrderDate]) = 5 Then "Friday"<br> when DayOfWeek ([Webshop.Orders.OrderDate]) = 6 Then "Saturday"<br> when DayOfWeek ([Webshop.Orders.OrderDate]) = 7 Then "Sunday"<br> default "Day of the week"<br> end

 +31 (0)20 240 21 20       

Videos and images courtesy of WEM Modeler. © 2019. WEM Modeler.
SitemapPrivacy - Terms - Company

 +31 (0)20 240 21 20       


Videos and images courtesy of WEM Modeler.
© 2019 WEM Modeler.
SitemapPrivacy - Terms - Company