Syntax for Defining Ranges and Exclusions in LOV Filters

When entering multiple values or filtering segment values, what character is used to define a range?

7 replies

Support Enginatics January 15, 2020
A Range of values is defined using a hyphen (-), such as ‘4/11/2025-4/20/2025’ for dates or ‘1110-1150’ for segments.
Customer January 17, 2020
And what syntax is used to define an exclusion?
Support Enginatics January 18, 2020
An Exclusion is defined by prefixing the value or range with a tilde (~), for example, ‘~4/14/2025’ or ‘~1110-1120’.
Customer January 19, 2020
If I manually type multiple non-range values into the Excel cell, how must they be separated?
Support Enginatics January 19, 2020
Multiple values entered directly into the cell should be separated by semicolons (;).
Customer January 21, 2020
Can I mix inclusions and exclusions in a single cell?
Support Enginatics January 23, 2020
Yes, you can mix formats, for example: ‘1110-1150;1210;~1111;~1120-1130’.