Splitting Serial Number into Date Field

[JDonskey9]

Hi Community - Was looking for help taking a field that stores Serial Number and splitting it out before the dash so that it could be reformatted into a date field and copied into a different property. 

i.e. If the serial number was 20110406-A0287103, then the manufacture date would split out the first section before the dash and copy that info into a date property on the Date of Manufacture field to be April 6th, 2011.

It looks like I may be able to use the formatting workflow functionality to get the numbers into a data format once they are split to only keep the data before the dash.

Any help wolud be greatly appreciated! Thank you! 

[SteveHTM · Accepted solution]

@JDonskey9 - it may be possible to use a regex flavour of the custom formatting functionality, but I personally would just dive into a custom code step to do both the splitting and the conversion ijnto a date string. You will likely find a more robust mechanism for teh logic by going this route.

Hope that's helpful.

Steve