Time format

[Shirley]

I need to export a table to Excel. The table has a field -
- CallTime--with time format. When I exported this table
to Excel, everything else is cool except the time format
is changed.

If I created a form on this table first, and then export
the form to excel, the time format will be keeped. But
this process is too much trouble especially when I want
to create some tables on the fly.

So how can I keep the time format in exproted file?

Thanks,

Shirley

 

[Ken Snell]

Wrap the time field with the Format function and tell it the specific format
to be used:

NewTimeFormatField: Format([TimeField], "hh:nn")