Importing date strings
I am trying to manipulate some "date strings" that I have imported from Excel to Filemaker 12. The strings are imported into a field called "Imported Date" - which is a text string.
An example string is "Thursday, December 15, 2011" - ignoring the quotes. This is captured as a text field in Filemaker. I want to convert this to a date value such as Dec-15-2011. I suspect that the answer lies in the use of the subsitute function.
However, I cant see how. Any suggestions ? thanks