importing timestamp as date
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?