Copy file - get file info

[Andrews (Andre)]

Reports<[Notes.Sheet(“Date”).Cell(“YYYYMMDD”)]><[Saved.Values(Of FileInfo)(“TemplateInformation”).Name]>
Hello there,
Using string above on Get file info step, the saved Excel file name it’s not following dateformat()
eg. \20200520 + <file_name>. i see \YYYY05DD + <file_name>.
either YEAR nor DAY get format just month is converted. Has someone same problem ?

[mukeshkala]

Hi @Andrews,

Welcome to the uipath community.

Try

yyyyMMdd

–
Mukesh

[Andrews (Andre)]

Thaks, i tried, trouble persists and it moves yyyy in uppercase as dd.
I tried also with single ', StudioX notify error before run.

[Mircea_Arhip]

Not sure what your trying to do. Can you please attach the workflow?

[Andrews (Andre)]

string.Format(“Reports{0}{1}”, Notes.Sheet(“Date”).Cell(“YYYYMMDD”), Saved.Values(Of FileInfo)(“TemplateInformation”).Name)

Sequence above doesn’t save file in dateformat as YYYYMMDD.
Results in filesystem is: YYYY05DDReport.xlsx

[Mircea_Arhip]

I think the problem is that you have Regional Settings in another language.
Please open project notebook go to Date sheet . What do you see in cell B9?

If you see YYYY05DD then this is the problem. Please modify the B9 formula with something else.

[Andrews (Andre)]

I see inside Date Op. and yes, i have different setting. Due to some limit I can’t change Reginal settings. so modified YYYY into AAAA format Dape Op. file show correct format but resulst doens’t chnage. will work out to find a solution.