BEGMONTH( ) BEGMONTH(date_value)

 

Date Function Returns a Date Value
Returns a date value representing the first day of the month from date_value. If date_value is left blank, then the current system date is used.

Examples:

BEGMONTH( )

Returns 09/01/2026 if the current system date is 09/24/2025.

(Date >= BEGMONTH( )) AND (Date <= ENDMONTH( ))

This expression can be used when filtering records to only show Statements dated between 04/01/2026 and 04/30/2026 if the current system date is 04/21/2026.

Other Resources

• Expression Examples
• Filtering Records
• Knowledge Base Article R11493 - All About Expressions
• Knowledge Base Article R11515 - Filter Expression Examples
• Knowledge Base Article R11487 - Working with Indexes, Filters, and QuickViews
• Knowledge Base Article R10750 - Report Writer, Filter, and WorkFlow Functions (provides link to downloadable .pdf)