monthStart()

The monthStart() function returns the date of the start of the Fiscal Calendar month based on a date input.

Syntax

monthStart(date)

Argument Description
date

(required)

An expression that results in a date value (i.e., a hard-coded date, a reference to a date attribute, or a function that returns a date value).

Where Available

Available in all places the expression or injected expression icon is visible, as well as within Filter fields on Cards, Tables and List/View sections.

Examples

Where Example(s)
Business rules: Set Value

Attribute expression

monthStart(2025-12-31)  

result within a Calendar Months enterprise: 12/01/2025

result within a 4-4-5 Retail Calendar December end enterprise: 11/23/2025

Field Editability expression

Tab Visibility expression

Due_Date__c > monthStart(today())
Business rules: Notification Subject It has been {!days(today(), monthStart(today()))} days since the month began.
Metric expression Initiative__t.Benefit__m.actual__d.timePeriod(monthEnd(Stage_3_Approval_Date__c)) - Initiative__t.Benefit__m.actual__d.timePeriod(monthStart(Stage_3_Approval_Date__c))

Initiative__t cumulative(Benefit__m, monthStart(Due_Date__c))

Updated on March 8, 2025

Related Articles