+ Start a Discussion
Glenn Nyhan 54Glenn Nyhan 54 

Process Builder Issue - Creating a New Record Using Date Field

I am trying to set Process Builder to creeate a new record from a date field. When the WPA Start Date reaches 182 days out from the start date I want to create a record that would be the next WPA level. But when I set up the formula I get the following error message (see image below). Not sure why this is occuring:

User-added image
Best Answer chosen by Glenn Nyhan 54
Maharajan CMaharajan C
Did you solve the issue then mark the best answer!!!

All Answers

HARSHIL PARIKH AKA:GovindHARSHIL PARIKH AKA:Govind
I would say try using the following formula,
 
DATETIMEVALUE([WPA__c].WPA_Start_Date__c) + 182
It looks like WPA_Start_Date__c field is not Date/Time field. It's Date Time field.

Check out this post also: https://developer.salesforce.com/forums/?id=906F00000008wx1IAA

Hope this helps and if it solves the puzzle the please mark it best answerd!
 
Glenn Nyhan 54Glenn Nyhan 54
Hi Govind,
 The WPA_Start_Date__c field is  a formula field which pulls its date from the Record Create date. Does that make a diffrence?

Thanks,

Glenn
 
HARSHIL PARIKH AKA:GovindHARSHIL PARIKH AKA:Govind
Ahhh.... I think that is way

Instead of using WPA_Start_Date__c, try to use CreatedDate
Just replace with CreatedDate like below,
 
DATETIMEVALUE([WPA__c].CreatedDate) + 182
OR
 
DATEVALUE([WPA__c].CreatedDate) + 182


 
HARSHIL PARIKH AKA:GovindHARSHIL PARIKH AKA:Govind
I would say this can be a approach you should take,

1) First create a field named WPA Start Date (with Date datatype) and have a workflow (you don't need process builder here) update that field.
How?
Create a workflow with the following criteria,
Evaluation Criteria: Evaluate the rule when a record is created, and any time it's edited to subsequently meet criteria
Rule Criteria:  ! ISBLANK( CreatedDate )
Time-Dependent Workflow Action: 182 Days
Now, inside the action click the field update and then select the WPA Start Date as a field to update.
Formula : DATEVALUE(CreatedDate) + 182

2) Now, go to the process builder and say when this field named WPA Start Date is not blank then go and create a record.

Hope this helps!
Maharajan CMaharajan C
Hi Glenn,

Try like in the below screenshot:

No need to inclue the Datevalue because its already date right? If its Date/Time then we have to use that.

User-added image


Can you please Let me know if it works or not!!!

If it helps don't forget to mark this as a best answer!!!

Thanks,
​Raj
Maharajan CMaharajan C
Did you solve the issue then mark the best answer!!!
This was selected as the best answer
Glenn Nyhan 54Glenn Nyhan 54
Thanks Raj! Problem solved!