Moving mm/dd/yyyy into separate fields
I'm working with an FMPro 9 db in which dates have been entered into a text field as mm/dd/yyyy (eg., 12/21/2008).
I need to move this data into three separate text fields: one for month, one for day, one for year. I have created those fields. How do I get the relevant numbers (but not the slashes) into the appropriate fields?