Fortnight field

Fortnight fields allow users to select a specific two-week period for their Record. This is useful if you are using a Form or a Subform to collect information on a two-week basis or if you are only interested in the two-week period of a specific action.

 No matter which week or which day a user will choose for a fortnightly Record (even or odd week), the final fortnightly Record will be automatically converted to the specified format and will always start with an odd week.


The Fortnight field format in ActivityInfo is YYYYWW-WW (e.g. 2020W3-W4). Users can directly type using this format or use the calendar to select a week.


In Pivot Tables, the Fortnight field can be added to rows or columns as dimension. It can be added as a measure using only the count and count unique Statistic.