Date Time Format

I'm using datetimeformat in a formula to derive the file name when the workflow is executed. The new requirement is to have the file name start with 'YYYY-MM-DD' and then + additional file name. Any idea on how I can accomplish this? When I use the below it gives me an error when I put % after the datetime now

"\\File Location\DateTimeFormat(DateTimeNow(),"%d%b%Y")+ FileName " + ".xlsx|||Tab Name"

Workflow

Developer

Data Investigation

Accepted answers

atcodedog05

Hi @Idyllic_Data_Geek

My bad updated the formula.

"\\File Location\"+DateTimeFormat(DateTimeNow(),"%Y-%m-%d")+" FileName " + ".xlsx|||Tab Name"

Hope this helps : )

All comments

atcodedog05

Hi @Idyllic_Data_Geek

change the formula to

"\\File Location\"+DateTimeFormat(DateTimeNow(),"%Y%m%d")+" FileName " + ".xlsx|||Tab Name"

Workflow:

Hope this helps : )

Filename.yxmd

Idyllic_Data_Geek

worked like a charm except for one minor thing. It is giving me the result as 2021101 instead of 2021-11-01

HomesickSurfer

Hi @Idyllic_Data_Geek

I like using the FileGet formulas, and; DateTimeStart() instead of DateTimeNow()...

Try this:

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703