Exporting time - no leading 0

  • Thread starter Thread starter Francois
  • Start date Start date
F

Francois

Hi,

When I try to export a 24h clock short time field, I am in
trouble because of the following resulting formats:
"01-16-2004 10:32:20" and "01-16-2004 9:32:20"

What I would like to see is:
"01-16-2004 10:32:20" and "01-16-2004 09:32:20"

I have not found any way to get a leading zero for the
time when exporting. I also haven't found a way to
actually export the short time.

Any help?
Thanks,
Francois
 
Use a query and for each field you want to format use the Format function.
Then export the query.
 
Back
Top