How to make an error tool limit range of inputs

Hi there,

I am trying to make an error message appear on an app. I have a workflow where we have to insert the period of the report, the format will be YYYYMM, i.e. June 2020 = 202006.

I would like to make an expression that says the expression can only be 6 digits long, the first 2 must be "20" and the last two can be from "01" to "12". I have tried a few things but not able to do it so far unfortunately. Any advice?

Thanks a lot

Test.yxwz

Accepted answers

Ladarthure

Hi @BillyL14,

here is a solution to do so,, I just used a block until done to do the test first and then set the test to be true on all records, can be done differently of course, and the test is left(period, 2 ) = '20' and lenght(period) = 6

Test.yxwz

All comments

Ladarthure

Hi @BillyL14,

Test.yxwz

BillyL14

hi @Ladarthure, thank you very much, would there be any way of customising the error message for that way?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703