Epoch and date formats in same column

[Divetafolla]

Hi Team,

i am having trouble combining some files using Alteryx since the date comes in two different formats, i already review the data in all the files and is the same, i just do not know why some filesare pulled with the correct date time format and others as EPOCH format, does anyone knows how could i fix this?

[geraldo]

@Divetafolla 

This excel date to date excel number format.
I made a workflow based on excel date calculation. Check if it could be the same

[binu_acs]

@Divetafolla One way of doing this