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.