This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
You need the date to enter into the data stream of the workflow? If so, for this purpose, if it has to be manual, I'd probably use the text input tool.
Either enter the date properly formatted in your required format, or just enter it as a string, make sure to format that field from that tool as string, then convert the field to the proper format downstream using either the Formula tool or the DateTime tool.
If I don't understand what you're trying to do here, can you clarify?
@satishchaganti If this date is random (i.e. not consistent such as the current date, etc) then you can build an analytic app by adding interface tools. This would allow the user who is running the workflow to be prompted for the date value when the workflow is executed. This value can then be added as a column via the formula tool.
In addition to @neilgallen's response, which I believe is the best solution if you want to be prompted for the date at run-time, youll want to add a Formula tool, or DateTime Tool to get the custom format you desire
In a Formula Tool, you can enter:
For the DateTime Tool, you'll want to select the "Date/Time Format to string" option at the top of the configuration, and then in the "Select the format for the new column" box, find your desired date format (dd/MM/yyyy)
When you run this, it will output a new column with the desired format of the date from your user input.