output to have date correctyl

[Hi2023]

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

[binuacs]

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

[Hi2023]

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

[Christina_H]

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

[Hi2023]

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

[binuacs · Accepted solution]

@Hi2023 Attaching a sample workflow for your reference

[Hi2023]

TY!!!