---
schema_version: "1"
id: dfffd2f0827b16396b8fc939a6775c45264592886e0eec62cf3dc8d40923474e
title: Helper Functions in Salesforce Spiff
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_functions_helper.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_functions_helper.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 803e26c4a0a193174b1b7a739bca979236e93d4ce38347af602f6359dbbfa9f5
description: Helper functions in Salesforce Spiff save time and provide clarity. A helper function is interchangeable with a standard function, but uses simpler syntax so you can create logic more easily.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# Helper Functions in Salesforce Spiff

Helper functions in Salesforce Spiff save time and provide clarity. A helper function is interchangeable with a standard function, but uses simpler syntax so you can create logic more easily.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Enterprise</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available for an additional cost in: <strong>Professional</strong> Edition with Web Services API Enabled</td></tr></tbody></table>

A helper function's name describes the output. Search or browse from the Helpers section of the function library when you're working with data filters, payout rules, or calculations in Designer.

![Functions tab, showing helper functions](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/sales_performance_management/images/spiff/spiff_functions_helpers.png)

The syntax for each helper function is only the function's name. Helper functions don't take any arguments.

 
| Helper Function | Description |
| --- | --- |
| `AllDates` | Returns the full date range for all your data, with no restrictions. |
| `AllTeams` | Returns all teams. |
| `AllTeamsDown` | Returns all subteams of the current team. |
| `AllTeamsUp` | Returns all parent teams of the current team. |
| `BeginningOfMonth` | Returns the first day of the month based on the current statement period's start date. The return format is YYYY-MM-DD. This helper function requires monthly statement periods. |
| `BeginningOfPeriod` | Returns the first day of the current statement period. The return format is YYYY-MM-DD. If your statement period cadence isn't monthly, this helper function returns the start date of the current period. |
| `CurrentMonth` | Returns the month number, 1 to 12, based on the current statement period's start date. For example, if the current statement period is May, this helper function returns `5`. |
| `EndOfMonth` | Returns the last day of the month based on the current statement period's start date. This helper function requires monthly statement periods. |
| `EndOfPeriod` | Returns the last day of the current statement period. The return format is YYYY-MM-DD. If your statement period cadence isn't monthly, this helper function returns the last date of the current period. |
| `IsMonth` | Returns `true` if the current statement period begins in the specified month, and returns `false` otherwise. For example, if the statement period is January, the `IsJanuary` helper function returns `true`. |
| `Now` | Returns the current date and time. The return format is YYYY-MM-DDT:hour:minute:second:millsecond, plus or minus the hours and minutes away from Coordinated Universal Time (UTC). |
| `PlanAssignmentEffectiveAsOfDate` | Returns the Effective As Of date for a user's plan assignment. The return format is YYYY-MM-DD. |
| `PlanAssignmentEffectiveUntilDate` | Returns the Effective Until date for a user's plan assignment. The return format is YYYY-MM-DD. |
| `PlanAssignmentEndDate` | Returns the date that a rep was unassigned from a plan. The return format is YYYY-MM-DD. |
| `PlanAssignmentEndDate` | Returns the date that a rep was unassigned from a plan. The return format is YYYY-MM-DD. |
| `PlanAssignmentStartDate` | Returns the date that a rep was assigned to a plan. The return format is YYYY-MM-DD. |
| `StatementPeriod` | Returns the current statement period date range, |
| `Today` | Returns the current date. The return format is YYYY-MM-DD. |