SYMPTOM:
When change format type back to Date for attribute "Day" (the default type) in Tutorial project, following warnings would appear.
Warning
The form selected display type is inconsistent with the data type of at least one of the expression(s) defined. Do you still want to continue?
Warning
The form selected display type is inconsistent with the data type of the selected column alias. This may result in SQL generation problems when running reports that use this attribute. You may need to use a different column alias to prevent this problem. Do you still want to continue?
CAUSE:
Attribute Day has the default data type as timestamp and format type as Date in Tutorial project. This warning is caused by that the format type in attribute editor is inconsistent with the data type. Format types compatible with Timestamp data type are:
Timestamp | Datetime, Date or Time depending on data |
Note: More detailed information regarding to data type, please refer to Appendix C: Data Type of Project Design Guide 10.x product manual.
According to the above information, in this project Date is inconsistent with Timestamp by designed, so the two warnings are supposed to be seen with no surprise.
ACTION:
In this case, the warning message can be ignored. However, it is always a best practice to choose a compatible format type according to the data type.
