How do I translate the macro of a filepath from prevdate = Format(DateAdd(“M”, 0, Now), “Mmm”) prevdate_year = Format(DateAdd(“Y”, 0, Now), “YYYY”) MonthNum = Month(Date) Source_Folder = “V:\Finance\Systems-Risk-ERM\OrderToCash\C2C\ACRA Biz Profile” & prevdate_year & “” & MonthNum & ". " & prevd…

Hi @Justine How about this expression? Year = Now.Year.Tostring Monthnum =DateTime.Now.ToString("MM") MonthMMM = DateTime.Now.ToString("MMM") “V:\Finance\Systems-Risk-ERM\OrderToCash\C2C\ACRA Biz Profile\"+Year+"\"+Monthnum+". "+MonthMMM [image] Regards Gokul

Choose current month dynamically

Help Forum

Justine October 28, 2022, 6:55am 3

Hi @Gokul001 , if i would like a month prior, it will be as follows?

“V:\Finance\Systems-Risk-ERM\OrderToCash\C2C\ACRA Biz Profile"+Year+“"+Monthnum-1+”. "+MonthMMM-1

Topic		Replies	Views
How to create folder according to last month title? StudioX studiox , question	6	550	July 20, 2023
Open Correct File Each Month Help	3	1295	July 9, 2018
How to Save the File in Current Month Folder Activities datatable , excel , uiautomation , robot , activities , studio , question , activities_panel	6	1208	May 30, 2022
Create folder name as Month Year (Jan 2024) Studio studio , question , project_panel	4	609	January 30, 2024
Expression to return first day of previous month Studio studio , question , activities_panel	6	2711	January 6, 2022

Choose current month dynamically

Related topics