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

Hi @lynnsong986 , Try the below Expression : new DateTime(Now.AddMonths(-1).Year,Now.AddMonths(-1).Month,1).ToString("MM/dd/yy")

Expression to return first day of previous month

Srini84 (Srinivas Kadamati) January 6, 2022, 5:00pm 4

Check below for your reference

Thanks

Topic		Replies	Views
How to get the date value of first day of previous month? Learning Hub datatable , studio	4	8164	February 28, 2020
Convert Date into specific Format in UI path Studio X StudioX studiox	3	2463	May 31, 2020
Write Cell for First of Current Month and first of current year Studio studio , question , activities_panel	3	33	October 23, 2024
How to get the date of the previous business day? Studio studio , assign	5	1472	April 26, 2023
Extract the date Studio studio , question , tools	9	388	August 11, 2023