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

Lori (Li) January 3, 2023, 8:04am 5

Thanks for your great help, Anil_G is the first, so I make Anil_G method as solution.

1 Like

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