Month fields store a year and month in the Gregorian calendar.
Date format
Because ActivityInfo is used by those coming from a wide range of backgrounds and cultures, often all working together on the same team, we have chosen to use the international standard format for dates everywhere in the application, which is “YYYY-MM”, regardless of the user’s language.
For example, May 2025 will always be formatted as “2025-05”.
Data entry
Although dates are always formatted in the format YYYY-MM, the data entry interface will attempt to automatically detect a variety of alternate formats, such as “July 2023”.
Desktop data entry
In the desktop interface, the date field includes a drop down calendar that can be used to select a field.
Importing
When importing, we recommend first formatting your data in the unambigous YYYY-MM format.
Limits
Month field values must between 1000-01 CE and 9999-12 CE.
Formulas
The YEAR function can find the year as number. For example, if the user selects January 2023 in the “Reporting Month” field, then the formula YEAR([Reporting Month]) will evaluate to the number 2023.
The MONTH function can find the month as a number between 1 and 12. For example, if the user selects January 2023 in the “Reporting Month” field, then the formula MONTH([Reporting Month]) will evaluate to the number 1.
To calculate the date of the first day of the month, you could use the functions above together with the DATE function: DATE(YEAR([Reporting Month]), MONTH([Reporting Month]), 1) .