Returns the first day of the quarter for a specific date or time value in Salesforce Spiff. The return format is YYYY-MM-DD. If you've specified fiscal year dates that are different from standard calendar dates, use the beginning_of_fiscal_quarter() function instead.
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_quarter(date_or_time)
Arguments
| Argument |
Required? |
Description |
| date_or_time |
Required |
The Date or Date & Time value to evaluate. This argument supports any date functions. |
Example
Return the first day of the quarter in which a deal closes.
=beginning_of_quarter(CloseDate)