How to change the date separator from mm/dd/yyyy to mm.dd.yyyy and add 00:00 in the end?

Help Activities
, , ,
8

@Greggy
If you have error like value is not a valid date format something like this

  • Keep a message box and print the hostDateFrom and check the format there if the format in the expression and the message box differ add the additional format in the expression like
DateTime.ParseExact(hostDateFrom.toString,{"MM/dd/yyyy","MM/dd/yyyy hh:mm:ss","dd.MM.yyyy"}, System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString(“MM.dd.yyyy hh:mm”)

You can simply add the any number of date formats inside the {“”,“”} and the formats should be seperated by comma

The above expression will look into array of string and choose the apt format as per the input string and convert them and return you the output of desired format

Regards
Sudharsan