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

@eric_wai You can refer my below post [image] String conversion to datetime Learn Hi @emm Please check [image] Mark as solution if this helps Thank you Mark as solution if this helps Thanks

@Srini84 thank you for the reply, but the data ive attained already has the slashes and the solution that you posted seem to be for when the string doesnt have the slashes. Thank you anyways. Maybe i can remove the slashes and use your method instead or maybe you have a better suggestion.

@eric_wai Can you share your sample string so that i can check and get back to you Thanks

“27/07/20” this was the sting that i got. thank you :slight_smile:

im also currently using the CDate(date_variable).Tostring(“dd/MM/yyyy”) method

Hi @eric_wai Below is the workflow i have made previously for the same issue [image] String conversion to datetime Learn Hi @emm Below is the workflow which gives your output looksLikeDate.xaml (5.3 KB) Output as below :- [image] Hope this workflow may help you to so…

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

Learning Hub

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
String is not recognized as a valid datetime - MM/dd/yyyy format is only working Studio activities , studio , question , date , datetime	9	12335	April 18, 2022
String was not recognized as aa valid datetime Studio	1	616	November 16, 2021
Convert string to date time Help	26	86924	June 10, 2022
DateTime Manipulation - String was not recognized as a valid DateTime Studio studio , question , activities_panel	11	1861	August 14, 2022
Convert date of string format to date time Help	42	7924	April 15, 2020

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

Related topics