AnsweredAssumed Answered

Importing date strings

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

Title

Importing date strings

Post

Hi,

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

 

Kaps

Outcomes