String to DateTime

this action parses a datetime datetime value from a string string , based on a custom format specification inputs & outputs inputs string — string value to parse from language — language used in the input string for month names and days of the week drop down with multiple languages format — string containing the datetime format specification format list — a list of formats (array of strings) that the input can match against when a format list is provided, it overrides the single format value this gives more flexibility when the input may match more than one potential format outputs date — parsed datetime value exact format parsing — boolean output that returns true when the output was parsed using an exact format from either format or format list false when a flexible or culture based parse was used as a fallback if you don't understand how format or format list should look, check the docid 57bsy8fjpnruimwc64ndk section behavior notes if neither format nor format list contains a matching format for the input string, the action will attempt to parse using the closest reasonable format based on the specified language/culture example usage drag action onto the canvas to get familiarized with it configure the inputs set the string you want to parse choose language provide either a format or a format list (better for multiple possible formats) if you don't understand how it should look like, check the #helpers helpers declare some variables to be used with the action assign the newly created variables save & run the process and then check instance to see the output use cases extracting datetime values from bodies of text coming from any source translating month names or days of the week from one language to another using the string to datetime and format datetime actions together handling inputs that may come in several different date formats reliably using format list tips the format and format list fields use standard net format specifiers which are documented here https //learn microsoft com/dotnet/standard/base types/custom date and time format strings the language selector determines which language to use when the desired format contains month names june (uk) | iunie (ro) | juin (fr) days of the week monday (uk) | luni (ro) | lundi (fr) make sure to escape letters used as format specifiers using quotes; otherwise those letters may be treated as placeholders for datetime fields and the action will fail to parse 📝 helpers using format list with literal text when your input string contains fixed text before or after the datetime value, you must wrap the literal parts in single quotes ' ' inside the format string correct example (based on your input) input the report was generated on 2026 02 11 14 35 and successfully uploaded to the system correct format list \[ "'the report was generated on 'yyyy mm dd hh\ mm' and successfully uploaded to the system '", "'the report was generated on 'yyyy mm dd hh\ mm\ ss' and successfully uploaded to the system '" ] why this works everything wrapped in single quotes ' ' is treated as literal text yyyy mm dd hh\ mm and yyyy mm dd hh\ mm\ ss represent the datetime format patterns the entire input string must match the format exactly ⚠️ if the literal text is not wrapped in single quotes, parsing will fail because letters like t, r, e, etc , are interpreted as datetime format specifiers hour format specifiers use the correct hour token depending on your time format hh → 24 hour format (00–23) hh → 12 hour format (01–12) when using hh, you should also include tt to support am/pm examples hh\ mm → 14 30 hh\ mm tt → 02 30 pm using the wrong hour specifier may result in incorrect parsing or unexpected time values