Return
-
Title
DateTime conversion error in a custom script -
Description
When runnning a process that calls on a custom script that includes a field in DateTime format, an error similar to the following may be seen:
"[809002] Conversion of 5/21/1986 12:00:00 AM to Date failed. [System.FormatException] String was not recognized as a valid DateTime."
-
Cause
The string that is being converted into a DateTime has the wrong format, and it is not being converted correctly. -
Resolution
The "FormatDate" function can be used to ensure that the DateTime is formatted correctly. For example, the script line throwing the error might look like this:
Person.PutValue("StartDate", StartDate)
The error can be resolved by modifying the line to look like this:
Person.PutValue("StartDate", FormatDate(Convert(StartDate,"DateTime"), "yyyy-MMMM-dd"))