I have one date string aa=2023-01-03, I need this date adjust one month before, EG. bb=2022-12-03, I use bb=string.Format(Cdate(aa).AddMonths(-1).ToShortDateString,“yyyy-MM-dd”), however, I get 2022/12/03, in fact , i need it’s value is 2022-12-03, who can help me, thanks.

@Lori Can you try this Cdate(aa).addmonths(-1).ToString(“yyyy-MM-dd”) Cheers

Cannot get the right date string format

ashwin.ashok ((TheCodingTheory)) January 3, 2023, 7:56am 3

Is this what you meant?

CDate("2023-01-03").AddMonths(-1).ToString("yyyy-MM-dd")

I think the issue is with using ToShortDateString.

Kind Regards,
Ashwin A.K

Topic		Replies	Views
Change String Date into another String Date Studio studio , question , activities_panel	5	467	October 2, 2023
String to Date Converstion RPA Discussions coding	6	2479	February 23, 2022
String Manipulation on Date format Studio activities , question	4	581	December 25, 2022
I want change string format 20201130 to date format 2020/11/30, can any one help me on this? Studio studio , question , activities_panel	5	673	July 3, 2022
Date Format like 31-Jan-2018 Help	5	1465	May 27, 2018