output to have date correctyl

Hi,

I was able to get the date to show but now its showing double on whre the file is landing-can you asisst?

currently:

YJS_DOD_CAS_Completeness_Score.xlsx|||._YJS_DOD_CAS_Completeness_Score2023-04-17

desired output

YJS_DOD_CAS_Completeness_Score2023-04-17

Reporting

Accepted answers

@Hi2023 Attaching a sample workflow for your reference

Sample_180423.yxmd

All comments

@Hi2023 Can you give some more clarity of what exactly you are looking for?

I am using a formula tool and creating filename 1 with this:

[Filename]+DateTimeFormat(DateTimeToday(),'%Y')

then on output there is the filename I am doing TakeFile/Tablename from field

and selecting change file/table name

and field containing Filename or part of File name

Filename1

but its giving duplicate filename with one 1 date so date part is fine but I dont want double filename

For Excel outputs, Change File/Table Name changes the name of the sheet, not the whole file. Try creating the whole file path in your formula and choosing Change Entire File Path. You'll need to include a sheet name too, ...Folder\FileName.xlsx|||SheetName

Can you explain what you mean by changing the whole path name in formula?

@Hi2023 Attaching a sample workflow for your reference

Sample_180423.yxmd

TY!!!

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703