Changing a numeric variable to date variable

I currently have a numeric variable that represents a date. ex Feb 20, 2019 is called 20190220.

I would like to change this field so that Alteryx would recognize 20190220 as a date and not a number. I would like to then create a new date field that contains year and month or month and year, order isn't important so long as Alteryx sees a date. So 201902 would be transitioned to Feb-2019 (or any format that Alteryx would recognize as month/year). Thanks in advance for any help.

Preparation

Accepted answers

cplewis90

@dkberry I have revised my solution to accommodate for this.

Date Help.yxmd

All comments

yalmar_m

Hi @dkberry,

I think a combination of the Select tool (to change the number to string), DateTime tool (to parse the number to a date) and the formula tool (to create the month-year you want to have) would work.

Please find my solution attached.

Best,

Yalmar

Solution.yxzp

cplewis90

@dkberry here is a workflow that does what you are asking. It converts the date using the datetime tool and then a formula tool to create the month year field.

Date Help.yxmd

dkberry

Thanks so much. When I run your solution I create a variable similar to Apr 2018. The issue I'm now having is I'm unable to sort accurately by this new month variable. Is there a way to create a variable that resembles Apr 2018 but Alteryx will recognize as a date variable?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703