AnsweredAssumed Answered

text into date?

Question asked by symbister on May 18, 2010
Latest reply on May 19, 2010 by comment_1

Title

text into date?

Post

Hi

 

using FMP 8.5 on mac os 10.5

 

i'm importing a set of data in which the date is represented as, for example "23 Jan 2009 05:00 PM WST", that is, in text. Any brilliant ideas on creating a calculation field to convert to a useful date? I've tried:

 

Date ( Middle ( Show Date; 4; 3); ( Left( Show Date;2)); Middle ( Show Date;8;4 ))

 

but this doesn't like the month coming in as three character text (and resolves as 23/12/2008). I may have to resort to a sort of lookup to render the month back into two-digit number, but that seems a tad long-winded...

 

any help appreciated

 

 

Outcomes