ERROR: Incorrect data type for operator or @Function: Time/Date expected
Posted on 2004-04-02
I am attempting to categorize documents based on an EffectiveDate (mm/dd/yyyy), by Year. Within the column of the view, I have the formula, "@Year(EffectiveDate)" intending to grab and display the year of this field. Most of the documents fall into the proper twisty of the year (1994, 1997, 2000, 2004, etc.). However, some documents are grouped under the twisty: "ERROR: Incorrect data type for operator or @Function: Time/Date expected". I have looked at the form in which the documents were created from, and especially this field. The field is a Date/Time & Computed.
For a document that appeared with the twisty: "Error...", I made the field "Editable", and typed in a new EffectiveDate. Upon saving, the document still appeared on the "Error..." twisty.
Can you help me out?