Date Column
Column Type = Text
The Date column contains the date of the hourly vector. The date field may be formatted as M/D/YYYY or MM/DD/YYYY.
NOTE: 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 Support 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 Window 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.
Date Column
