I need to convert dates that are in MMYYYY format. See attached. Some fields are blank. I'll need the new date format to be queryable so I can find records with dates prior to, after, etc. a specific Month/Year. Some fields may be in the 19XX range if it matters.
Thanks in advance.