0

I have two fields - Project Created Date and Onboarding Completed Date and I am trying to figure out how many weekdays are between the 2 dates.

Formula

(5 * ( FLOOR( ( Project__c.Onboarding_Completed_Date__c( 1900, 1, 8) ) / 7 ) ) + MIN( 5, MOD( Project__c.Onboarding_Completed_Date__c( 1900, 1, 8), 7 ) ) )
-
DATEVALUE (expression) (5 *  (FLOOR( ( CUST_CREATED_DATE( 1900, 1, 8) ) / 7 ) ) + MIN( 5, MOD( CUST_CREATED_DATE( 1900, 1, 8), 7 ) ) )

Getting the following error

Error when encoding row-level formula: Syntax error. Extra '('

But I am not seeing an extra "("

Any help would be greatly appreciated.

Improve this question

1 Answer 1

Reset to default
0

I'm sure you've noticed by now, but you have an extra "DATEVALUE (expression)" in your formula.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .