Text to custom date

[afkl99]

Hi, 

I have a text column in the form: MMM.YY (ie Jun.2017, Jul.2017...)

And Im trying to convert it to a date in the form MMM YY (preferably as June 2017)

Any ideas? 

Thanks! 

[fhill · Accepted solution]

I just entered 'Jun.2017' and 'Jul.2017' into Query Editor, and I was able to right click my column and change type to Date.  Now that's it's a date, I can change the Date Formatting under Modeling to MMMM yyyy.

If this doesn't work on your end, can we get screen shots of your data?

FOrrest

[afkl99]

Thanks for the quick reply! 

I used an R script to import my data so I just changed my script and it now works perfectly