I HADN'T given much thought to changing a timestamp from text to a timestamp. Didn't even think it was necessary. But it turns out there are some instances where it is. Daniel Shanahan shows us how:
FileMaker Server has a timestamp on its log. However, when you export the log data and import it into FileMaker Pro the timestamp does not sort properly, since it is a text field. This video shows one way to parse the FileMaker Server timestamp text and turn it into a FileMaker Pro timestamp.