Hi, I have attained the string “27/07/20” from a pdf and would like to put that int excel to subtract some days from it, but i found out that in the excel it is not detecting this format. So i decided to change it to a date time date, but i realized that this string could not be recognize as a date …

@eric_wai You can try as below [image] sample = sample.Replace(“/”) 2)sample = sample.Substring(2,2) + “/” + sample.Substring(0,2) + “/” + sample.Substring(4,2) 3)sample = convert.ToDateTime(sample).ToString(“dd/MM/yyyy”) Mark as solution if this works Thanks

String was not recognized as a valid DateTime dd/mm/yy

Learn

Pratik_Wavhal (Pratik Wavhal) July 2, 2020, 8:02am 8

Hi @eric_wai

Below is the workflow i have made previously for the same issue

Hope this may help to solve your issue
Mark as solution if this helps you and like it

Happy Automation

Best Regards
Er Pratik Wavhal

Topic		Replies	Views
Error: String was not recognized as a valid DateTime Help	15	21492	April 13, 2023
Assign: String was not recognized as a valid DateTime Help	8	7665	January 20, 2021
!String was not recognized as a valid DateTime Help activities , error , variable , string	10	4163	January 8, 2020
String is not recognized as a valid datetime - MM/dd/yyyy format is only working Studio activities , studio , question , date , datetime	9	10255	April 18, 2022
String was not recognized as a valid DateTime when read cell with date format Help question , academy	7	1160	January 9, 2021

Most Active Users - Yesterday
ashokkarale
Anil_G
Yoichi
yangyq10
postwick
chandreshsinh.jadeja
aravindbalineni123
Parvathy
aya
PRASHANT_GABHANE
More details...

String was not recognized as a valid DateTime dd/mm/yy

Related Topics