Expressions in Error Message Tool

Cool, then this worked for me: [#1]<DateTimeParse(ToString(DateTimeYear(DateTimeToday())-3)+"-01-01", "%Y-%m-%d")

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

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!!

All comments

@kas if the limitation is coming in the query and is not getting affected by the user's selection, is the goal just to have your Error Message expression be dynamic to the past three years of dates so they know they won't get older data? i.e. they can't select a start date greater than three years old?

Yes, so if they select an older date than what the query is pulling, they will receive the error message.

Cool, then this worked for me: [#1]<DateTimeParse(ToString(DateTimeYear(DateTimeToday())-3)+"-01-01", "%Y-%m-%d")

Worked like a charm...thank you!!

Kim

Happy to help!

Hello again!

Hope you can help again...I'm looking to have the error pop up when the date is more than 6 months from the current date. (easy for me to adjust the years with your solution, but not sure how to adjust for months)

Thank you!

Kim

Look at using similar logic but using a DateTimeAdd function to add 6 months from the current date!

I had tried something like that, but I am uncertain of how to write it correctly, I get syntax errors.

What have you tried? Should just be [#1]>DateTimeAdd(DateTimeToday(),6,'months')

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.

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

Screenshot 2025-07-11 093009.png

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

😊

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

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!!