302 Found

Found

The document has moved here.

month

Syndicate content

By using a custom formula, you can create a report that displays the records where a date field in the record is equal to the current month (or previous or next month). If you want to base a view on the [Date Created] field value, then create a new report, choose Table report, and within the Filters section select the right button to enable filtering.

February 5th, 2009 - 6:02 PM

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:

February 5th, 2009 - 6:02 PM

Here is a formula that will calculate the third Friday of the current month:

NextDayOfWeek( FirstDayOfMonth(Today()) - Days(1), 5 ) + Weeks(2)

It can be broken down to the following steps:

1) find the first day of the month containing today
2) go back one day to the last day of the previous month
3) find the next Friday (the number 5 represents Friday)

February 5th, 2009 - 6:02 PM
302 Found

Found

The document has moved here.