DAY( ) DAY(date_value)

 

Date Function Returns a Numeric Value
Returns the day value of date_value (1-31). If date_value is blank, then the current system date is used. Returns 0 if the date_value is equal to "mm/dd/yyyy".

Examples:

DAY( )

Returns 5 if the current system date is 11/04/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)