breadcrumbDescription
Returnerer antallet af arbejdsdage mellem en øverste og lavere dato eller et lavere tidspunkt i Salesforce Spiff, bortset fra weekender og helligdage.
| Tilgængelig i: både Salesforce Classic (ikke tilgængelig i alle organisationer) og Lightning Experience |
| Tilgængelig i: Enterprise, Unlimited og Developer Edition |
| Tilgængelig mod merpris i: Professional Edition med Web Services API aktiveret |
networkdays(start_date, end_date, list)| Argument | Påkrævet? | Beskrivelse |
|---|---|---|
| start_date | Obligatorisk | Den nederste grænse for det datoområde, der skal kontrolleres. Dette argument understøtter enhver datofunktion. |
| end_date | Obligatorisk | Den øverste grænse for det datoområde, der skal kontrolleres. Dette argument understøtter enhver datofunktion. |
| liste | Valgfrit | En liste over datoer, der skal udelades fra optællingen. Omslut listen i parenteser med kommaseparerede værdier, f.eks. [date("2025-01-20"), date("2025-09-19")]. |
Returner antallet af arbejdsdage mellem en kontraktstartdato og lukkedato for handler, der er lukket i andet kvartal af 2024. Udelad 31. maj.
=networkdays(DealToAccountContractStartDate, CloseDate, [date("2024-05-31")])
We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.