The problem is that you have imported the data from another database and Excel is not recognizing the contents of the Date column as dates.
(1) Create a new column. Then select the column and right-click on it and select Format Cells... (2) Select Date and then select the format that looks like 3/14/01 13:30. Click OK. (3) Enter 1/1/01 12:00 in the second row. (4) In the third row enter "=DATEVALUE(C3)+TIMEVALUE(C3)" where C3 is the original date column. (5) Copy the new formula to the other rows. (6) Save the file and try it again in EnviroInsite.
