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

system (system) Closed December 1, 2024, 3:05pm 6

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

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