Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Interactive Tool - Date Coming out of Date Interface and Action to Report Text

alyssa_sedai
8 - Asteroid

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.

 

2 REPLIES 2
Claje
14 - Magnetar

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:

 

 CommunityDateFormat.PNG

alyssa_sedai
8 - Asteroid

Thank you!  That worked.

Labels