Having a trouble on using text box for date input

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?

Text Input date.yxwz

Date Time

Accepted answers

All comments

flying008

Hi, @cathywong1127

1- In the Action tool, you need use option 'Update Value with Formula',

2- Formula :

IIF(IsEmpty([#1]), [Destination], [#1])

IIF(IsEmpty([#1]), DateTimeToday(), [#1])

录制_2024_04_22_11_33_17_746.gif

cathywong1127

not understand, could you amend it in my workflow?

cathywong1127

sorry, I try your method but seems it does not work, could you amend my workflow directly?

flying008

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.

cathywong1127

Still does not work, I have changed value with formula

cathywong1127

flying008

Hi, @cathywong1127

FYI.

录制_2024_04_23_10_33_24_100.gif

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335