Creating file name dynamically

[Neelima1]

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

[apathetichell · Accepted solution]

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

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

[cjaneczko]

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 · Accepted solution]

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