converting format back to number

Question

Hi Community,

I am trying to upload data it has come to my attention that some of pricing column contains date formats in error.

The date format issue is clearly down to problems with the client but what would be the best way to insure that this column is converted back to a number. i have added mock data for you consideration.

In short the mock data has 1000 in and is then converted to date in order to test converting it back to a the 1000 in Alteryx.

please advice.

Thanks

Capture.PNG

atcodedog05 · Answer

Hi @moshood

Try this formula

DateTimeDiff([Date],'1900-01-01','days')+2

Hoping Date field is in date format.

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Converting a date into a number (similar to excel).yxmd

moshood · Answer

Hi thanks for getting back to me but this does not seem relevant  i need to convert the date format back to number.

thanks

AkimasaKajitani · Answer

Is the Data source from Excel?

If then, please refer this discussion.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Date-to-Date-Value/td-p/136436