Get the Current Month of the Year

The month of the year can be calculated by using two Formula Language functions@Month and @Select (e.g., January through December).

How It Works

The @Month function returns a numeric value between one and twelve, corresponding to the month of the year. The function returns a numeric one for January and continues through December, which returns a numeric twelve. When combined with the @Select statement, the corresponding text value is stored in the Result.

Implementation

To implement this solution, insert the following formula in an action button, column, or default value for a field. Optionally, replace @Today with a date or field. The @Prompt statement is used for illustrative purposes and can be removed or updated as desired. However, if removed, be sure the formula contains a main expression (i.e., Result) as the last statement in the formula.

Result := @Select(@Month(@Today);
 "January";
 "February";
 "March";
 "April";
 "May";
 "June";
 "July";
 "August";
 "September";
 "October";
 "November";
 "December"
 );
@Prompt([Ok];"Current month"; result);

Figure 14.4 depicts the result when the button is pressed in the month of April.

Figure 14.4. Example month of the year

Note

Using the @Today and @Now functions in column formulas will result in the refresh icon being permanently displayed on the view. Where possible, dates should be stored in a document field that is referenced in the column formula.