Maint End Column (optional)
Column Type = Text
The optional Maint End column allows the user to specify the day/month/year that a maintenance period ends. A maintenance period will be repeated every year on the same month and day and will end on the same month and day. Serial maintenance dates specified earlier than 1980 will be ignored, unless the study begin date is prior to 1980.
NOTE: The default setting is 1/1/1980 in both columns in the Resources, Resource Modifier and New Resources tables. If the default date of 1/1/1980 or "FUEL" is specified, the value in the Fuel table will be applied.
NOTE: If you do not want to specify a maintenance period, enter 1/1/1980 in the maintenance end date and a 1/2/1980 in the maintenance begin date in the Fuel table only.
NOTE: Entries in the Maintenance Schedule Table overrides any data in the Maintenance Rate , Maint Begin or Maint End columns in the Resources, Fuel, RMT or New Resources tables.
All date columns in an input database and project Change Set will automatically be converted to column type Text. This change was necessary to solve a problem Microsoft has built into their core XML data handling routines that save and retrieve date variables in time zone referenced values. This gave rise to the troublesome circumstance that when a user would save a Change Set or XML dataset with date columns in the table, if the same dataset were later opened in another time zone, the day portion of date variables would have changed. This created a significant issue for transfers of project databases to EPIS for our clients who are not on Pacific Time. The date conversion to text solves this problem and makes dates independent of time zone. The automatic column type conversion will be logged on the Status screen when an unconverted input database is opened in this version. Date fields currently being used in linked input tables in Excel will need to be manually converted to text. Data entry in these text columns must also conform to a strict input format.
Maint End Column
