Expressions in Error Message Tool

[kas]

Hello,

I am trying to use the Error message tool in conjunction with Interface tools to have it return an error message when they select a date outside of a time frame for the Start Date. That time frame is no earlier than the 1st of the year 3 years prior. So currently that would be 1-1-2022, but next year it will be 1-1-2023 and so forth each year, so it can't be a set date. The SQL query is set to restrict the data from not going back further, but they will need to be able to select date ranges within that time frame. I've used this tool before, but with a set date so it was easier.

Screenshots of the Error message tool (current expression works only during 2025), Interface tools, and SQL query portion that restricts data as reference below.

Thank you,

Kim

[kas]

@alexnajm 

I had tried the following:

>DateTimeAdd(DateTimeFirstOfMonth(), -6, "months")

But when I tested with a date selection further back than 6 months, the error message didn't pop up.

Tried your version, and same, error message doesn't come up.

[alexnajm]

Worked fine for me! You said six months beyond today right? so six months into the future would be +6 months, not -6 months...

[kas]

@alexnajm 

Not into the future, but not more than 6 months back (that's why I put -6)

😊

[alexnajm · Accepted solution]

Ah "when the date is more than 6 months from the current date" sounded like future not past!

Then flip the greater than to less than and use the negative number

[kas · Accepted solution]

@alexnajm 

OK...thanks for bouncing back and forth with me!

I totally forgot to flip it to the less than symbol at the beginning...but, also it needs to be left at a positive '6' and it works!

Thanks again for all your patience!!

[alexnajm]

Happy to help!