Convert a string of numbers to short date

I have excel general formatting my dates to number strings and I would like to have alteryx convert them to mm/dd/yyyy

EX: "43763" transformed to "10/25/2019"...... "43762" transformed to "10/24/2019" etc.

Is there a function to do this?

Date Time

Accepted answers

The 2nd select tool changes string to int . Share your wf if this does not help .

Try DateTimeAdd('1900-01-01',[Field1] - 2 ,'days') .

When I try this formula, I receive an error message: "Formula: Invalid type in subtraction operator."

Currently my date column is a V_String and switching it to Int32 or Int64 does not resolve the issue. Any ideas?

Additionally, is there a way for the output to be in dd/mm/yyyy format versus "yyyy-mm-dd" your solution displays?

Thanks!