Forum Discussion

afkl99's avatar
afkl99
Frequent Visitor
9 years ago
Solved

Text to custom date

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! 

Need Help
  • fhill's avatar
    fhill
    9 years ago

    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

2 Replies

  • fhill's avatar
    fhill
    Resident Rockstar
    9 years ago

    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's avatar
      afkl99
      Frequent Visitor
      9 years ago

      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