AnsweredAssumed Answered

Fixing time entries.

Question asked by FMNewbie on May 27, 2011
Latest reply on Jul 22, 2011 by FMNewbie

Title

Fixing time entries.

Post

FMPro Advanced 11; Mac OS

Okay... so I have a db with various time fields with several thousand records.  Unfortunately, the data was imported from the old MS Excel files, the formats got all messed up.  The actual numbers are still there, but the same field in various records might be displayed as:

2:34

02:34

0234:00

002:34

This might be wishful thinking, but is there a way I can write a nice easy script that will go through all the records and fix them all to dilplay in the 02:34 format?? 

Outcomes