Hello Is it possible to parse string with varying format to datetime? Eg. if the date could be either “20-6-2024” or “20-06-2024” or “1-12-2024” etc. So the day-month-year will always be in the same spot, but the leading zero might be missing from days/months below 10. I was hoping that the code…

Yes the type is String Array. Here is an example workflow for you: [image] [image] You can use ParseExact function in an Assign activty. Also if you want to use TryParseExact function, it must be in the if condition because it returns a boolean value

Parsing datetime with varying format

Help Studio

SorenB November 28, 2024, 3:04pm 5

Thank you.

Apparently it was the DateTimeStyles.None that was required.

1 Like

Topic		Replies	Views
Convert String to Date Time with varying formats Studio string	8	5099	July 20, 2020
Problem with datetime.ParseExact() Help studio	6	10360	April 26, 2019
Convert to DateTime that are in different formats Studio studio , question , workflow_diff	4	2822	May 3, 2022
Help with date parser Help	5	1791	February 14, 2019
How to Check the date format from a given input(string) Studio studio , question , activities_panel	2	2583	May 27, 2021

Parsing datetime with varying format

Related topics