Time/Date Formatting when Exporting

[Jon Crain]

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

[comment]

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

[Jon Crain]

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

[Jon Crain]

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.

[comment]

Try:

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

& ":" &

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

&

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

[Jon Crain]

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