Forum Discussion
The following system error occurred: Type mismatch.
I managed to solve the problem. I made a column [ОтчетныйПериод] format in the model as in the original column in the MySQL database. Then in the model created another column, the value of which is copied from the column [ОтчетныйПериод]. In the end, I assigned a date format to a new column and it worked. Maggie, thanks for responding.
Hello, Maggie! Data in the source table is stored in text format. In the model, I translate them into a date format. In the source table (MySQL) I can not change the source text format. Any idea how to get around this problem? (attached screenshots).
I managed to solve the problem. I made a column [ОтчетныйПериод] format in the model as in the original column in the MySQL database. Then in the model created another column, the value of which is copied from the column [ОтчетныйПериод]. In the end, I assigned a date format to a new column and it worked. Maggie, thanks for responding.