I need a function that can take the following values and return me the date in a format: MM-dd-yyyy.
2014-12-22-New Orleans Report
2014-3-1-San Fransico Report
I think in every scenario there will be the same number of dashes - so I will always need to look for the 3rd dash and then take everything before that to parse out the date - then format.
I'm working on various code at the moment and I was hoping someone could give me the exact syntax on making this work correctly. Thank you sincerely in advance!