Validating the date in date interface tool

I am using date interface tool to select last day of the month and run the workflow but want to bring a control that only last month of the day is selected to run the workflow.

I tried to add an error message to stop if the last month of the day is not selected but couldn't crack correct expression.

Please suggest correct option to my solution.

Date Time

Accepted answers

danilang

Hi @Inactive User

Connect an Error Message interface tool to the Q output of the Date tool. In the Expression box enter

[#1] != ToDate(DateTimeTrim([#1],"lastofmonth"))

This compares the selected date with the last date in that particular month. If they don't match it throws an error and the user has to select another date.

Dan

All comments

aatalai

A bit of while since I played with interface tool, but thinking more of a work around, could you not set it that the user only gets to pick the month and in the workflow it sets it to the end of the month. Or alternatively they input whatever date, but again in the workflow you convert it to the end of the month.

@Inactive User would that work?

unknown

My workflow is built to work on date mode i.e., any date but for accurate results i want the user to select last day of the month if wrong date selected I need an error message that not the last day

In second option which you mentioned which tool I could use after date interface face tool to select last day of month?

Because after date interface tool I have action tool to run.

IMG_20240202_172349.jpg

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703