I am trying to add “Now.ToString(“yyyy-MM”)” on place of a folder’name “2022”, so that the current year is always indicated in the path. I was able to do that with the help of a colleague, however I am not sure how to do it without having to use the {0}, …? (see picture)
Hi @maria.mitova,
Place it inside the double quotes like below.
"C:/Arivu/Pdf/Name"+Now.ToString("MM/dd/yyyy")+"Exchange.xlsx"
Regards,
Arivu
Unforutnately it does not work. I get an errorr message:
Hi @maria.mitova ,
Here’s a small workflow which creates a folder/file path using the date format.
This might help you.
TimeFormat.xaml (4.3 KB)
Your syntax is incorrect. Literal text goes inside quotes while expressions (ie now.tostring) stay outside the quotes:
“V:\xxxxxxxxx. Payroll\Payroll Run Documentation\Exchange Rates" + Now.ToString(“yyyy”) + “\” + Now.ToString(“yyyy-MM”) + " Exchange Rates Payroll.xlsx”
Thank you for your answer, but it still does not work. This is the original link:
V:\XX\XXXXX\05. Payroll\Payroll Run Documentation\Exchange Rates\2022\Exchange Rates Payroll.xlsx
This is what I did after your explanation and I got an erorr message:
“V:\XX\XXXXX\05. Payroll\Payroll Run Documentation\Exchange Rates\2022\ " +Now.ToString(“yyyy-MM”)+” Exchange Rates Payroll.xlsx"
What I need to do is to replace 2022 with Now.ToString(“yyyy”) and add Now.ToString(“yyyy-MM”) in front of the last file name.
V:\XX\XXXXXX\05. Payroll\Payroll Run Documentation\Exchange Rates\ 2022\ 2022-01 Exchange Rates Payroll.xlsx
Thanks!
Hi @Indrajit_Banerjee , unfortunately I cannot open it with Studio X.
If that is your goal, this is your code:
“V:\XX\XXXXXX\05. Payroll\Payroll Run Documentation\Exchange Rates\” + Now.ToString(“yyyy”) + “\” + Now.ToString(“yyyy-MM”) + " Exchange Rates Payroll.xlsx"
By the way, don’t copy/paste right from these posts. The double quotes won’t be correct. Paste into Notepad, fix all the double quotes to the regular ones, and then copy/paste into UiPath.