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

system (system) Closed January 6, 2023, 8:05am 6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

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