AnsweredAssumed Answered

importing timestamp as date

Question asked by TomGallivan on May 30, 2011
Latest reply on May 30, 2011 by TomGallivan

Title

importing timestamp as date

Post

I'm working with data that will be imported from a csv. One of the fields, "Created Date" appears as" 'Oct 30 2009 9:34 AM" when viewed in a spreadsheet program (Open Office Calc). The leading apostrophe identifies it as being a numeric format, I believe. In Open Office if I use the function DATEVALUE on data in that field and then format the cells as Date I receive the rseult I'm looking for, e.g. 10/30/2009, which can then be sorted in chronological order.  

I can't figure out how to achieve the same result in FM Pro , having tried all sorts of appraoaches (nooby here and to FM  btw). Any ideas?

Thanks,

Tom

Outcomes