Returns the first day of the fiscal quarter for a specific date or time in Salesforce Spiff. The return format is YYYY-MM-DD. If you haven't specified fiscal year dates in Spiff, this function falls back to a standard calendar year.
Required Editions
| Available in: both Salesforce Classic (not available in all orgs) and Lightning
Experience |
| Available in: Enterprise, Unlimited, and Developer
Editions |
| Available for an additional cost in: Professional Edition with Web
Services API Enabled |
Syntax
beginning_of_fiscal_quarter(date or time, offset)
Arguments
| Argument |
Required? |
Description |
| date_or_time |
Required |
The Date or Date & Time value to evaluate. This argument supports any date functions. |
| offset |
Optional |
An integer that overrides the start of the fiscal quarter by one month. Positive values shift the start forward in time and negative values shift the start back in time. |
Example
Return the beginning of the fiscal quarter based on the beginning of the statement period, using the BeginningOfPeriod helper function, and adjust the value by one month back in time.
=beginning_of_fiscal_quarter(BeginningOfPeriod, -1)
