Time Question

[Guest]

I have a field that is formated as a number field, but it is supposed to
represent the time a person placed an order. An example would be 2038. I need
to have this formatted as 20:38. How can I do this?

Thank you

 

[Guest]

Hi

Set the format to Short time
Set the input mask to 00:00;0;_

 

[Guest]

How can I set it to short-time if its number format?
The only options are: General Number, Currency, Euro, Fixed, Standard,
Percent, Scientific.

 

[Guest]

It is up to you but if the number is meant to be a short time then this is
what it should be.

MAKE A BACKUP 1ST then on a copy of the DB change the format of the field in
the table to short time.

 

[George Hepworth]

Convert the field to a Date/Time datatype and format it as Short Time