Convert to date

msh

Hi,

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

Thank you.

Mads

PaulT

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.

Thanks,

Paul