Multiple Contains, possible to enter a dynamic range for contains?

[wonka1234]

hi,

I have an analytic app where a user enters in the month and year like so : 202209 , 202210 etc.

Is it possible to adjust this to a range?

Is there anyway to adjust this so I can type in  202207-202209  or any of those?

[kathleenmonks]

Hi @wonka1234,

If you have a specific set of values that you want to use, I would suggest using a list box interface tool instead. You can manually set values or choose from an external source and the user can select multiple or just one date. Then you can generate a custom list with a comma separator to replace the portion of the contains formula.

[danilang · Accepted solution]

hi @wonka1234 

You can make this work by restructuring your filter to include the range and then adding a formula to the Action tool to replace the two months

If the hyphen is there, the formula replaces the "202210" with the left part and "202211" with the right part.  If there's no hyphen, it replaces both "202210" and "202211" with the left part.  The main drawback in this approach is that it expects the user to type correctly.  The workflow contains a simple Error Message tool to ensure that only one of the two allowed formats is used

@kathleenmonks' suggestion is cleaner since it doesn't allow the user to make mistakes in type, but unless you read the month values dynamically from and external source, you'll have to redeploy the workflow when the list of months in the tool is no longer valid.    You'll also need to change your filter to use IN instead of Contains [Month] in ("202209","202210") and replace everything in the brackets 

Dan