How to convert String date with spell out months to date format

[blitz45]

My example is slightly a little different from the ones I have been seeing in the threads. 

I want to be able to convert YYYY-MM (ie. 2021-OCT) to YYYY-MM-DD (ie. 2021-10-01). Is there a way to do that? I found a long way of doing it using formula but wanted to see if there's a simple and short way? 

Thank you!

[blitz45]

@RyanMaxwell  wow, capitalizing the m's made the difference! why is that? Thank you!