Error: String '' was not recognized as a valid DateTime

[ashokkarale]

@rajababu.mandapati,

Use this snippet. You can add all possible formats in the array and it will always give you output in “dd/MM/yyyy”

strOutputDate= DateTime.ParseExact(inputDateVariable, {"dd/MMM/yyyy","MM/dd/yyyy","dd.MM.yyyy"}, CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")

Learning Resource:

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues

This FirstAid Tutorial will describe how DateTime parsing issues can be analyzed and handled. Click spoiler text when in a hurry: Example Assignment Following Excel data will be processed and the corresponding Quarter is to calculate for the particular task date Input data: [input_raw] Quarter Calculation Quarter = CInt(Math.Ceiling(YourDateTimeVar.Month / 3 )) Initial Implementation [initial_flow_raw] tmpTaskDate = DateTime.ParseExact(row("Date").toString.Trim, "dd.MM.yyyy", CultureInf…

**Added missed ToString format at the end.
**Added learning resource