converting format back to number

[moshood]

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  

[AkimasaKajitani]

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

[moshood]

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

thanks 

[atcodedog05]

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 😀👍