Apex Code Development You need to sign in to do that
Don't have an account?
Nayana 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)
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.
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)
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.
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!