Choose current month dynamically

[Justine]

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 & ". " & prevdate

to "V:\Finance\Systems-Risk-ERM\OrderToCash\C2C\ACRA Biz Profile" + DateAdd.now.ToString(“YYYY”) + Month(Date) + ". " + now.ToString(“Mmm”)

The end result should look like this:
V:\Finance\Systems-Risk-ERM\OrderToCash\C2C\ACRA Biz Profile\2022\10. Oct

I took some reference from this thread below, but am still seeing an error in the dialog
How to Choose the current month folder

Thanks for the help in advance!

[Gokul001 (Gokul Balaji)]

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

Regards
Gokul

[Justine]

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

[Gokul001 (Gokul Balaji)]

Hi @Justine

You don’t need to change in this expression

Year = Now.Year.Tostring 

Monthnum =DateTime.Now..AddMonths(-1)ToString("MM")

MonthMMM = DateTime.Now..AddMonths(-1)ToString("MMM")

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

Check out the Monthnum & MonthMMM expression above

Regards
Gokul

[Marius_Puscasu]

Hello @Justine ,

What about this topic?

30+ No code DateTime formats with UiPath activity

Dear community, The Format Value activity helps us to format a generic value into more that 30+ datetime formats, without being necessary to write any VB or C# code.

1. How to use the activity?

<a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/8/3/f/83f111dce4fc40f9d34fd6ef392d0a149b73e3c2.jpeg" data-download-href="/uploads/short-url/iPd2n0xewaCF6oG5drY5lp57ozM.jpeg?dl=1" title="image">[image]</a>

2. How your format…

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

Best regards,
Marius

[Justine]

@Gokul001 , thank you so much for the help!

[Justine]

@Marius_Puscasu , thank you! Will take a look.

[Gokul001 (Gokul Balaji)]

Hi @Justine

Check out the Tutorial

Recollect the basics of Date Format, String Manipulation and LINQ

Hello Everyone, I would like to present this post who are looking for the expressions related to the Date Format, String manipulation and LINQ Basic of Date formatting In this below topic, you will learn about Date Formats Convert datetime to week of year System.Globalization.CultureInfo.CurrentCulture.Calendar.GetWeekOfYear(System.DateTime.Now, System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.CalendarWeekRule,System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.Fi…

Date Expression

Hello Everyone, Hope you are doing good I would like to present this post who are looking for the expressions related to the Date Expression Get the Week Count W"+System.Globalization.CultureInfo.InvariantCulture.Calendar.GetWeekOfYear(Today,System.Globalization.CalendarWeekRule.FirstDay,DayOfWeek.Monday).ToString [image] Get the 5 Business days count Enumerable.Range(0, new DateTime(2023,12,31).DayOfYear + 1).Select(Function (x) New DateTime(2023,1,1).AddDays(x)).Where(Function (x) Not (x…

All about Datetime - UiPath

Hi All, My recent post on datatable [All About Datatable- UiPath] (All about Datatable - UiPath) was received well in forum with great feedbacks and many suggested to provide some tutorial on topics which are discussed often in our forum In regards to that I would like to share the commonly used expression for DATETIME conversion Let’s get started one by one 1. Get Current Date in string format Datetime.Now.ToString() (Output - string type - “dd/MM/yyyy hh:mm:ss”) **To get only current da…

Regards
Gokul

[Justine]

@Gokul001 , useful references, thanks for providing the thread!