Issues with changing cast dataset to date

Lyss1006

Hi! I am trying to change the data created column to date, but when I check append rows, it says the column is changing to timestamp. I am not sure what I am doing wrong.

ColemenWilson

During the append, the matching fields being appended default to the most compatible data type between the appends sources. So if you change one source to Date, but the other is Date Time, it will change the data type to Date Time. You'll need to ensure that the data type for all inputs to your append are cast to Date. Add an Alter Columns tile here:

Alternatively, you could cast to date after the append.

ColemenWilson

During the append, the matching fields being appended default to the most compatible data type between the appends sources. So if you change one source to Date, but the other is Date Time, it will change the data type to Date Time. You'll need to ensure that the data type for all inputs to your append are cast to Date. Add an Alter Columns tile here:

Alternatively, you could cast to date after the append.