Expression to return first day of previous month

[lynnsong986]

Hello this expression I have
New DateTime(Now.Year,Now.Addmonths(-1).Month,1).ToString(“MM/dd/yy”)

returns “12/01/22”, but I need it to be the first day of the previous month “12/01/21”, can someone please help?

thanks so much in advance

[Constant_Roux]

Hello,
Maybe just add a condition and if your current month is 01 then sub 1 year to the result ?

[supermanPunch (Arpan)]

Hi @lynnsong986 ,

Try the below Expression :

new DateTime(Now.AddMonths(-1).Year,Now.AddMonths(-1).Month,1).ToString("MM/dd/yy")

[Srini84 (Srinivas)]

@lynnsong986

Check below for your reference

How to get the date value of first day of previous month?

hi guys, I am struggling to create a variable in UiPath studio that would look at the current date and define the first day of the previous month. Do you know if this is even possible? I am trying to avoid setting up this value in excel file and get UiPath to calculate this value itself. Basically so far i have Date_Now variable which is simple “now” calculation in DateTime type. 2nd variable is Date_NowString which is Date_Now.ToString(“dd/MM/yyyy”) with a String type. Is there any calculat…

Thanks

[Jobin_Joy]

You can use the below one.

LHS:FirstDayOfPreviousMnth
RHS:new DateTime(Date_Now.Year,Date_Now.Month,1).AddMonths(-1)

Thank you

[lynnsong986]

Thank you all for your kind help!