Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.
How do I create a report that shows me only records where my date field "Start Date" is equal to or greater than the first day of this month?
1. In a new report or an existing one, create a custom calculated column. To do so, make sure that 'Custom columns' is selected in the 'Columns' section. Once you've added the normal columns you'd like to appear on the report, check off the box next to 'Define a calculated column.'
Set the field 'Type' to 'Duration,' and enter the following in the Formula box:
[Start Date] - FirstDayOfMonth(Today())
2. In the 'Filters' section, click the right radio button to enable filtering. In the expanded section choose '<Custom Column>' from the "Select a field" drop-down list. Select "is greater than or equal to" in the middle field, and enter the value "0" in the text box.