Date Time Format

[Idyllic_Data_Geek]

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"

[atcodedog05]

Hi @Idyllic_Data_Geek 

change the formula to

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

Workflow:

Hope this helps : )

[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

[atcodedog05 · Accepted solution]

Hi @Idyllic_Data_Geek 

My bad updated the formula.

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

Hope this helps : )

[HomesickSurfer]

Hi @Idyllic_Data_Geek 

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

Try this:

[Idyllic_Data_Geek]

Thank you

[Idyllic_Data_Geek]

another question. My output file(excel) has 3 tabs. By default tab is only created when there is data entry. My new requirement is to create a tab regardless of any data present or not. How can I accomplish this?

[HomesickSurfer]

@Idyllic_Data_Geek 

Completely blank sheet (tab), or with field  and no records?