hello, I would like to use the text box input to update the date, if the user inputs the date in the text inbox, it will use the date input manually, otherwise, it will use today's date as a holiday date. But it doesn't work. the date is still used today. "2024-02-12" I wanna use the date input in "text input" as the holiday date. Can anyone help me with this?
Hi, @cathywong1127
1- In the Action tool, you need use option 'Update Value with Formula',
2- Formula :
IIF(IsEmpty([#1]), [Destination], [#1])
or
IIF(IsEmpty([#1]), DateTimeToday(), [#1])
not understand, could you amend it in my workflow?
sorry, I try your method but seems it does not work, could you amend my workflow directly?
Take a look at your screenshot, your Atcion tool is using the Update Value option, this needs to be changed, and you need to specify the update item as a formula value, please see the animation.
Still does not work, I have changed value with formula