I am using the Report Text node in Reporting to add the following to a PDF
Date Range: January 1, 2018 - January 10, 2018
I have 2 Interactive Tools that allow the user to select a date. If I set the action prompt to - Update Value: January 1, 2018 when I run it interactively and set a date (for example January 5, 2018) it changes the Date Range to: 2018-01-05 - January 10, 2018. Is there any way to change it so that it writes January 5, 2018 or at least 1-5-2018?
I have attached the workflow.
Thank you.
Solved! Go to Solution.
Hi,
You're really close to what you need here! The Date tool automatically outputs dates in the Alteryx Date format, which is why you are seeing this issue.
If you change your action type to "Update Value with Formula", you can use the following formula:
REPLACE([Destination],"January 1, 2018",DATETIMEFORMAT([#1],"%B %e, %Y"))
This will format the date value from your date input to be the same as your expected output format.
For the end date, the formula is basically the same:
REPLACE([Destination],"January 10, 2018",DATETIMEFORMAT([#1],"%B %e, %Y"))
Here's a quick screenshot of your first Action Tool:
Thank you! That worked.