Archibus Calendar Dates Table

The Archibus Calendar Dates (afm_cal_dates) table is used for calendar reporting by the Archibus Web Central View Analysis. Archibus prepopulates this table with a list of dates between 01/01/1990 and 12/31/2060. These dates can be used to summarize data by date values. For example, the dates can be used to summarize counts of work orders closed on each date.

Note that for some reporting purposes, the performance metrics framework may better serve your date reporting needs. However, for pick lists of dates and queries that require a validating list of dates, the afm_cal_dates table might be required. Also, unlike performance metrics, reports that use afm_cal_dates do not have to run a workflow rule to generate the results.