This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
How do I convert the date coloumn to date currently alteryx does not recognize it as such? RecordID medium country date transactionRevenue transactions 1 000000 email (not set) 20140814 72.422758 19 2 000001 email (not set) 20140821 79.606785 39 3 000002 email (not set) 20141016 72.228595 19 4 000003 email (not set) 20141124 107.566242 19
Hi! The solution to this problem is to use the DateTime tool located in the Parse tool box. To use this tool the date field must be set as a string in order for the DateTime tool to convert the field to an actual date. Once that is set, make sure to select "Convert From String Field to Date/Time Field" in the Date/Time tool. The second thing you will want to do is make sure the "Formatted Input String Field" is set to your date field in this case "Date". In the list below select the format that your string data is currently in (your case yyyymmdd). The output of this tool will add a new field to your data that contains the properly formatted Date/Time field that you can now do calculations with.
Actually if you use the formula as given (because of the anomolies), you will get '2015-11-26' which is one day off. You may need to adjust your formula by a day (i.e., subtract 2) to get the answer you are wanting.
The date field looks the same way '20180813' however was coming in with a double data type.
I somewhat had come up with a bit of a solution after I asked and then watched the live training yesterday on date and time parsing. What I ended up doing was converting the field to a string and then used the DateTime parsing tool to convert it into a usable date format.