I have a set of data that contains individual dates as field names in the format "yyyy_mm_dd". I'd like to eliminate the underscores and simply have an 8 character string as the header for each field.
I've tried using a SubString formula with the Multi-Field Formula tool, but am getting error messages about the formula returning a string while the field contains values. I then tried using the ToString and ToNumber functions in the formulas but it's just not working out as desired.
How can I convert the string in my field headers while retaining the values within that field?
Much appreciated!
