Exporting time field

[Loretta Davis]

I need to export a time field currently stored as 1:00pm
into 24 hour time 1300 as text. The query I'm using is so
complex, I was not able to save this to a temp table with
a format on the time field. Any suggestions would be
welcome.

 

[Greg Kraushaar]

You puzzle me. MSA does not have time fields. It has date fields that
it uses for both Dates and times

If you are using a date field, then it doesn't store as 1:00 PM, but
as 0.541666666666667.

You can then use formatting to control the look of the output
Format(dtm,"hh:nn") or something like that

If you are using a roll your own Time field, then you are on your own,
unless you supply more information

Regards Greg Kraushaar
Wentworth Falls Australia
(Do not email - the reply address is a Spam spoofer)
(If you really must, remove all UCase and numbers)