TODATETIME
Syntax
TODATETIME (string_expression)
Description
Converts string data to a DateTime value.
Arguments
| string_expression | The string value to convert. |
Returns
A DateTime value.
Remarks
Trying to convert any data except String results in an error.
DateTime formats reflect the local settings of the computer where the Connect on-premise agent is installed.
Example
If MyEntity.ExpireDate contains a string value of "May 3 2011", the following formula converts the value to a true date time:
TODATETIME(MyEntity.ExpireDate)
Returns: 5/3/2011