"How to Convert Dates in Various Unknown Formats to dd.MM.yyyy in UiPath?"

Hi @Valigatla_Revathi

Try using DateTime.Parse: DateTime.Parse is more flexible than DateTime.TryParseExact as it attempts to automatically detect and parse various formats without needing a predefined list.

Here’s how you can do it with invoke code:

Try
    Dim parsedDate As DateTime = DateTime.Parse(yourDateString)
    Dim formattedDate As String = parsedDate.ToString("dd.MM.yyyy")
Catch ex As Exception
    ' Handle parsing error if needed '
End Try
2 Likes