I am trying to convert a column called: Book Fiscal Month String to an actual date.
The Month string date consists of dates such as: 2018-M01, 2018-M02, 2018-M03, etc.
Here's the catch, the dates are in fiscal months. I would like to convert the fiscal dates to the following:
I've scoured the web and haven't found anything to help me figure this out, or maybe I'm just being a nob.
Thanks for any insight.