Convert a string of numbers to short date

[mlanham]

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?

[benakesh]

Hi @mlanham ,

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

[mlanham]

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!

[benakesh]

@mlanham ,

Date format can be changed to dd/mm/yyyy  using datatimeformat()  or  datetime tool. 

Can you share sample data ?  

[mlanham]

Here are screenshots from the select tool to display the type and from the raw data.

Thank you for the formatting help there

[benakesh · Accepted solution]

Hi @mlanham ,

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

[mlanham]

Fantastic - this worked! Thank you for all your time on this.

[sahartz]

Hi,

If I also have seconds. How do I present them? I get only the date without the time.