Is there a way to export a Time field that would export the Time Format along with it? For example...

If I have a Time field and I put "20" in it, I get "8:00 p.m."

When I go to export that field (or convert it to text or what have you) it simply exports "20". I want to force it to export the formatted time.

I've tried a number of different ways, but nothing seems to work as flawlessly as I'd like. Any help?

jon

In the 2nd export dialog, there's an option to 'Apply current layout's data formatting to exported data'.

Hmmm. That would totally work for the question I gave. However, I must have misstated my situation...

I'm not as much exporting using the standard export option, but exporting via a long script/AppleScript into a Word Document. Perhaps this topic actually belongs in the AppleScript forum...

I suppose it would be possible to export that field to a file using the method you described, then importing that file into a text field, but there has got to be a better way. For now I won't start a new topic in the AS forum.

jon

For example, you can do it with dates pretty easily, like this...

DayName ( Date ) & ", " & MonthName ( Date ) & " " & Day ( Date ) & ", " & Year ( Date )

That will turn any date like 3/5/08 into Wednesday, March 5, 2008.

Try:

Mod ( Hour ( TimeField ) - 1 ; 12 ) + 1

& ":" &

Right ( "00" & Minute ( TimeField ) ; 2 )

&

Case ( TimeField < 43200 ; " AM" ; " PM" )

Perfect!

I was just reading about calculating time by the number of seconds, and that seems to be the key to that calc.

Thanks!

jon