+ Start a Discussion
Nayana Pawar 5Nayana Pawar 5 

Process Builder: Convert text to a DateTime using formula

I am using a process builder to assign value to child from the parent object.
I have one relevant field on both,but having different data types so I am facing the issue.
Parent Field data type: Text (skdate_finish__c)
Chid Field data type : Datetime (Invoice_Finish__c)
User-added image
By using the formula I am trying to get the value : DATETIMEVALUE(skdate_finish__c) This is not working for me.
Please help me to solve this issue.
jenish shingalajenish shingala
DATETIMEVALUE is always calculated using GMT time zone and can't be changed.
When entering a date as a literal value, surround the date with quotes and use the following format: YYYY-MM-DD, that is, a four-digit year, two-digit month, and two-digit day(So your skdate_finish__c should be in mentioned format).
If the expression does not match valid date ranges, such as the MM is not between 01 and 12, the formula field displays #ERROR!
Nayana Pawar 5Nayana Pawar 5
I am not getting any error.