Apex Code Development You need to sign in to do that
Don't have an account?
Amogh Babhale Need help to update process builder to update the field with formula
Hi All,
Hope doing well,
How can we use below formula in process builder the formula is working fine in workflow field update but getting lots of errors in when trying to use in Imidiate action (Field update) of the process builder.
Formula is below
[Case].Subject & TEXT( MONTH( [Case].DateCreated__c ) ) & "/" & TEXT( DAY( [Case].DateCreated__c ) ) & "/" & TEXT( YEAR( [Case].DateCreated__c ) ) &
TEXT ( HOUR (DATETIMEVALUE([Case].CreatedDate ))) & TEXT ( MINUTE(DATETIMEVALUE([Case].CreatedDate )))
The error that I am gettingn is that "The formula expression is invalid :Funtion Hour may not is be used in this type of fornmula"
Purpose of the this formula is that whenever case is created provide the Unique subject with the Subject line +date and time saperated by each value(Subject linke+date+year+hour+miniute)
Is there any way we can use this formula in process builder to update the field.
Thanks !!
Hope doing well,
How can we use below formula in process builder the formula is working fine in workflow field update but getting lots of errors in when trying to use in Imidiate action (Field update) of the process builder.
Formula is below
[Case].Subject & TEXT( MONTH( [Case].DateCreated__c ) ) & "/" & TEXT( DAY( [Case].DateCreated__c ) ) & "/" & TEXT( YEAR( [Case].DateCreated__c ) ) &
TEXT ( HOUR (DATETIMEVALUE([Case].CreatedDate ))) & TEXT ( MINUTE(DATETIMEVALUE([Case].CreatedDate )))
The error that I am gettingn is that "The formula expression is invalid :Funtion Hour may not is be used in this type of fornmula"
Purpose of the this formula is that whenever case is created provide the Unique subject with the Subject line +date and time saperated by each value(Subject linke+date+year+hour+miniute)
Is there any way we can use this formula in process builder to update the field.
Thanks !!
Please use HOUR(TIMEVALUE([Case].CreatedDate)
Same for calculating Minute as well.