Exporting time field

  • Thread starter Thread starter Loretta Davis
  • Start date Start date
L

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.
 
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)
 
Back
Top