AnsweredAssumed Answered

Importing date strings

Question asked by Kaps_1 on Aug 8, 2012
Latest reply on Aug 8, 2012 by Kaps_1


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