Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Add dates to Text Report tool ready for email

anhdo92
8 - Asteroid

Hi,

 

I'm trying to add two different date fields to the text tool and expect to see it shows up correctly in the email once workflow finishes running (please see below). Run date is the time the workflow is run. Recs Date is the date picked up from the files' name.

Unfortunately the tool doesn't seem to pick up values from these fields. Any idea is very much appreciated!

 

Current text:

 

anhdo92_0-1631607736196.png

 

Text expected to be seen in email

 

anhdo92_1-1631607974175.png

 

Many thanks

 

 

3 REPLIES 3
RolandSchubert
16 - Nebula
16 - Nebula

Hi @anhdo92 ,

 

do you see the expected result, if you attach a Browse tool to the output anchor of the Report Text tool? 

Best,

Roland

sparksun
11 - Bolide

sparksun_0-1631613406340.png

 

 

danilang
19 - Altair
19 - Altair

Hi @anhdo92 

 

If you need the Dates output in a specific format, you'll need to generate these outside of the Report Text tool.  I used a Formula tool to create 2 "Display" fields and used those in the report text

 

danilang_0-1631624021836.png

 

danilang_1-1631624041683.png

 

Dan

 

 

 

Labels
Top Solution Authors