Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Creating file name dynamically

Neelima1
8 - Asteroid

Hi

 

We are generating the output in CSV format, want to generate the output file name dynamically. formula I have written is throwing error message, please advice

 

"Term Hours_"+DateTimeToday()+ "_BW_Loaded by" +.csv

3 REPLIES 3
apathetichell
20 - Arcturus

.csv is not a string  - how about - "_BW_Loaded by.csv"

 

datetimetoday() - is not a string - how about datetimeformat(datetimetoday),"%Y-%m-%d")

cjaneczko
13 - Pulsar

The following should work. You can adjust the DateTime in the format of your choosing.

 

'Term Hours_' + datetimeformat(datetimetoday(),'%m-%d-%Y') + '_BW_Loaded by.csv'
Qiu
21 - Polaris
21 - Polaris

datetimetoday() - is not a string but it can be used as a String. 😁

0717-Neelima1.png

Labels
Top Solution Authors