Epoch and date formats in same column

Question

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?

epoch.xlsx

binu_acs · Answer

@Divetafolla One way of doing this

Date_050923.yxmd

geraldo · Answer

@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

convertepoch.yxmd