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

Marius_Puscasu (Marius Puscasu) October 28, 2022, 7:04am 5

Hello @Justine ,

What about this topic?

Perhaps would help you solve the issue in a easier way.

Best regards,
Marius

1 Like

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

Most Active Users - Yesterday
Anil_G
ashokkarale
Ajay_Mishra
Gautham_Pattabiraman
BHUSHAN_NAGAONKAR1
vrdabberu
ABHIMANYU_THITE1
lrtetala
samantha_shah
shyamala_shyamu
More details...

Choose current month dynamically

Related Topics