In the Dashboard Designer, when creating a calculated field with the function "ToDateTime()", an error may occur:
The reason the error may occur has to do with the data the dimension of the KPI contains and more specifically, with the format of the data.
The function "ToDateTime()" accepts dimensions that contain DateTime values with the following format:
Month - Day - Year
Hence, before updating the KPI from within a process, we would need to make sure that any DateTime variables used as a KPI dimension are properly formatted, using the "Convert DateTime to Text" action: