Need to Change Date Format from string to Date

[ppr (Peter Preuss)]

In addition to:

@Shanmathi

Hi @manojmanu.rpa
formattedDate = CDate(your_variable).ToString(“dddd, dd/MM/yyyy hh:mm:ss”)
This will output a string in the format: “Friday, 20/01/2022 00:00:00”

In general we would recommend to use ParseExact for converting the string into a dateTime
Afterwards we can reformat as needed

DateTime.ParseExact(YourInputString, YourFormat, System.Globalization.CultureInfo.InvariantCulture)

Format parts (in/out) are as:

Still we would recommend to check if the Time part is really breaking Month / year in the Position

Kindly note: Friday 20th Jan 2022 does not exist, it was a Thursday so parsing this date will fail