importing time fields

[foodminer]

I converted a DBF file to FileMaker and noticed that the time fields contained and eight digit number instead of a time. I also tried importing the data into FileMaker and still got the same result. Is there a way to import time fields looks like a time.

Thank you

[Lee Smith]

Dates and Times can be problematic when you Convert and/or import the data. You might have better results if you create the fields, and then import the data into actual Date and Time fields using a validate calculation.

Alternately, you could import them into text fields and then clean them up using a calculation field, or a script.

What does the time data look like. i.e. does it have the : colons?

Lee

[foodminer]

Hi Lee,

Thanks for your response.

The field should show 6:00 p.m. but instead shows 18000000. Another field shows 21300000 instead of 9:30 p.m.. I noticed that the first four digits indicate military time minus the colon.

What are your thoughts?

[Lee Smith]

Here is a quick sample of how you can use the Auto Enter for a changing the data on import to Time, provided that the data always has the 2 digit for the hour.

HTH

Lee

ImportTimeData.fp7_copy.zip