Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to add dynamic (Today's date) to report output (render)?

ShantanuDagar
8 - Asteroid

As per subject, I want to add today's date to rendered report as the report is run daily.

 

Any help is appreciated.

 

Thanks

7 REPLIES 7
Raj
16 - Nebula

use the formula to update the current date 
DateTimeNow()

OllieClarke
16 - Nebula
16 - Nebula

Hi @ShantanuDagar you can use the DateTime Now tool, and bring the field into a report text tool so you can add it to your report however you want. 
Alternatively, the Report Header tool can also be used to include the current date. 

 

Hope that helps

 

ShantanuDagar
8 - Asteroid

How to suffix it on output file name on render

ShantanuDagar
8 - Asteroid

Hello @OllieClarke 

 

Can it be suffixed to output file name somehow instead of inside report which is just a table.

OllieClarke
16 - Nebula
16 - Nebula

Hi @ShantanuDagar 

Yes it can.

reportsuffix.PNG

If you group by the date, then you can append it on to the filename

 

Hope that helps,

 

Ollie

 

ShantanuDagar
8 - Asteroid

Thanks @OllieClarke 

 

Works as intended.

Joaodasilva
6 - Meteoroid

If the goal is to have today's date in the output file name only, you can just drag that formula tool before the render and group it by date as suggested above and it will do the trick.

 

Screenshot 2023-12-21 131713.png

Labels
Top Solution Authors